Results 1 to 2 of 2

Thread: Julian dates

  1. #1
    Join Date
    Dec 2003
    The Netherlands

    Unanswered: Julian dates


    I have several date fields with a Julian date lay-out. I found the following code to change the fields into a 'normal' format:

    =DATE(IF(0+(LEFT(A1,2))<30,2000,1900)+LEFT(A1,2),1 ,RIGHT(A1,3))

    What I don't understand about it is, what the LEFT and RIGHT does and what the (A1,2) and (A1,3) do. And where do I place the code? In a new field or do I place it in the same field as the one with the Julian dates?


  2. #2
    Join Date
    Mar 2004

    Left right formula

    Using Excel, you can check what a function does by choosing Help On this Function. Eg for the LEFT function it says this:

    LEFT returns the first character or characters in a text string, based on the number of characters you specify.

    So left (A1,2) returns the two left most characters from the value in Cell A1, eg if cell A1 had the value 1000 in it, then =left(a1,2) would return 10.

    You should put your formula adjacent to the value you are querying otherwise it will overwrite the value, and can't report anything. You would probably also create a circular reference, but that's another matter completely.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts