YYYYMMDD -> YYYYDDD

jzajde1 · Post by **jzajde1** » Thu Jun 04, 2015 9:02 am

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

chulett · Post by **chulett** » Thu Jun 04, 2015 9:13 am

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.

jzajde1 · Post by **jzajde1** » Thu Jun 04, 2015 11:11 am

@Chulett -

Worked like a charm! Thanks for your help.

Jared