@DatePart("Date", DP_DAYOFYEAR) doesn't work in PBCS

User_2014

Hi,

I'm trying to get the the no of the days in a year, like day 215 or day 265 in PBCS but seems @Datepart function still doesn't work in PBCS or am I missing something?

Any one knows if there's been an update in Planning/PBCS to use @Datepart right away without having to write the code in the old way of converting from Essbase format YYYYMMDD and writing the code required to replace the @Datepart function?

Thanks.

User_2014

Worked with @CalcMgrGetDayOfYear and it did the job!

User_2014

Worked with @CalcMgrGetDayOfYear and it did the job!