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.