DSXchange

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

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.

@Chulett -

Worked like a charm! Thanks for your help.

Jared