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.