Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

User_2014Oct 21 2021

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.

This post has been answered by User_2014 on Oct 21 2021
Jump to Answer

Comments

adim
A fresh install got around the issue. Any idea why this would happen?
1 - 1

Post Details

Added on Oct 21 2021
1 comment
364 views