Hello -
I am trying to convert a string(which is a date) YYYYMMDD to YYYYDDD.
The YYYYDDD columns need to remain in a decimal format since this field is going to be packed in the CFF Stage.
Please advise.
Thanks,
Jared
YYYYMMDD -> YYYYDDD
Moderators: chulett, rschirm, roy
I'd look at the StringToDate() followed by DateToString() with %ddd for the day on the way back to a string. Then if you need to, convert the final string to a number. Not aware of a way off the top of my head to do this with a single function.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers