Day of year

[kcolborn]

I'm trying to convert a date to the format YYddd (day of year). Is there any way to do this inside a transformer? I've been trying different things for a couple of days and can't get anything to work.

[gateleys]

I'm trying to convert a date to the format YYddd (day of year). Is there any way to do this inside a transformer? I've been trying different things for a couple of days and can't get anything to work.

Assuming your input date is in the format YYYY-MM-DD, try this-

Code: Select all

Oconv(Iconv(InLink.YourDate,"D-YMD[4,2,2]"), "DYW[2,3A]")

[kcolborn]

I finally got this one to work:
trim(OCONV(date(),"D2YJ")," ",'A')