Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting weird date format
Message
From
03/09/1997 10:57:22
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00048265
Message ID:
00048274
Views:
24
>>>One section of the data contains the date in the following format YYYDDD where YYY is the year (097) and DDD is the day number of the current year (245). I'm quite familiar with VFP's date functions and have converted form a number of formats in the past, but this one has me stumped. Unless I have completely missed it, I don't know of a "day of year" function in VFP.
>>
>>What about about 245 + the first day of the year which will give you the current date for 245th day.
>
>Yea, that makes sense. Since I have the year, I ll use the date functions to create an extra field that contains the first day of the year and add the number of days from the DDD portion to this field to come up with the current date in the format I require. I should have thought of this myself. Thanks for the response.

To avoid double replacement, you may want to store this to a memory variable and only replace the final value. :)
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform