Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Julian date
Message
 
 
To
23/10/2002 20:23:41
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00714610
Message ID:
00714616
Views:
17
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
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform