Thanks Sergey - I might have to make you my honorary uncle since you have been so helpful to so many of us on this board.(s)

Thanks
Gaylen

>Yep, it's two last digits of the year and number of days from the begining of the same year.

ldDate = Date()
>lnJdays = ldDate - Date( Year(ldDate ),1,1) + 1
>lnJdate = ( YEAR(ldDate ) % 100 ) * 1000 + lnJdays
>? lnJdate, PADL( lnJdate, 5, "0")
>

>>I need to record a transaction date in julian date format (YYDDD). When I use sys(1) or sys(11) I get a number such as 2452571 for todays date. I assume the DDD is the number of days since January 1st, so I probably could subtract the julian number for January 1 from the transaction date.
>>
>>Anyone else have a better solutionm. The (YYDDD) is required to report insurance policy information to NCCI.
>>
>>Thanks
>>Gaylen