General information
Category:
Coding, syntax & commands
>>I have a DATE() to YYYYDDD function already but I received a file full of YYYYDDD instead of dates and need to get dates.
>>
>>Does anyone havce a quick algorithm/function already? Before I waste time reinventing the wheel.
>>
>>TIA
>
>**************************************************************************
>FUNCTION YYYYMMDD
>**************************************************************************
>* Description....... Convert strings in format of yyyymmdd to date format
>LPARAMETER tcStr
>lDate = CTOD( SUBSTR(tcStr,5,2) + "/" + SUBSTR(tcStr,7,2) + "/" + SUBSTR(tcStr,1,4) )
>RETURN lDate
This is YYYYMMDD
instead YYYYDDD he needs where i think DDD is the number of the day in the year
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only