Information générale
Catégorie:
Codage, syntaxe et commandes
>>>>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.
>
PMFJI
The 245th day of the year would be First_Day + (245 - 1)
Adding 245 would get you the 246th day.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement