2 Replies Latest reply: May 15, 2014 10:03 AM by Deborah99C _ RSS

    Convert Date to Julian Date

    Deborah99C _

      Hello!

       

      I am attempting to use the DateToJulian(,) function in the calculated fields (unsuccessfully) and would appreciate any help!  What I currently have is a standard date format of 11/20/2008 and need to convert it in order to perform some additional coding based on the report and project dates.

      My date field is set up as character, and I set up my calculated field as character.  However, when I select the DateToJulian function and plug in the date field, and the default value of 5, I get an error message of "operand types".  This is what my formula looks like:

      "DateToJulian(,5)"

      I'm not sure what I'm doing wrong?  Do I need to modify the original field before setting up the calculated field?  Am I coding the calculated field wrong?

       

      Thanks!

       

      Deborah