Julian Date

[GeneN24]

Can someone help me format a date/time field (TRANS_DATE) into Julian Date format(2003204).

Thank you

 

[synapsevampire]

There are UFL's to handle this:

http://support.crystaldecisions.com/library/kbase/articles/c2009191.asp

Easier than coding it out...

-k

 

[MrBillSC]

I haven't found any Julian date formatting in Crystal. You could use a formula to create a numeric value.
To do this use the DatePart function to get the year of the datefield. Then use the DateDiff function to calc the number of days from Jan 1 of datefield to datefield. Put these together to get your Julian date.

I hope there is an easier way, but I have not seen it.

mrbill

 

[GeneN24]

I believe this information worked. However, can someone tell me how to place leading zeros in front of the julian date (to always display 3 bytes) in cases the date is < 100 ? For example January 1 should display &quot;001&quot; instead of &quot;1&quot; .

Thanks for all of your help so far.

 

[GeneN24]

I figured this out. Thanks for your help.