This content has been marked as final. Show 2 replies
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:
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?