Posts by _channelx_

Re: Jd Edwards Julian Date Conversion

Quote from turtle44

Julian dates are normally 5 digits; what is the 6th digit used by Jd Edwards?

Not in my experience, all of the Julian dates I have come into contact with have been 6-7 digits long. The 6th digit in Julian Date represents the century value.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]

Quote from daddylonglegs

With a formula you can just use:

=DATE(LEFT(A1,3),1,RIGHT(A1,3))

for VBA perhaps see solution(s) suggested here - I haven't tried them.....

http://www.systeminetwork.com/…ms/showthread.php?t=43630

or perhaps a simpler formula that would also cater for A1 being a formatted number rather than text, i.e. leading zeroes might not exist....

=DATE(A1/1000,1,MOD(A1,1000))

Display More

daddylonglegs,

Both of your formulas work like a charm for the JD Edwards Julian Date: 105210 = 7/29/2005. Thank you for your help, this is much easier than the way I was trying to do the conversion!

Re: Lock Unlock Cells Based On Format

Hey thanks for the input guys, I will try these out and see how they work with what we are trying to accomplish![hr]*[/hr] Auto Merged Post;[dl]*[/dl]

Quote from turtle44

Of course, you will need to add code to protect/unprotect the workbook in order for the cell protection to matter.

Right, this is another problem that I am running in to. Should I ask this in another thread or can I continue to ask in this one?

Is anyone here familiar with how to convert the JD Edwards Julian date format into standard Gregorian date, and can it be done using VBA?

Please note that the JD Edwards Julian date is different than the standard Julian Date and uses 6 digits instead of 7.

I am looking for a way using VBA to lock and unlock multiple cells based on cell formatting (ex. to only allow edits to cells with a green border). Is it possible to write a macro that will accomplish this on command (not when the workbook is opened)?