Skip to Main Content
Forums

Analytics Software

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!

Is @DATEDIFF function format should be DD-Mon-YYYY?

hyperionMar 12 2018 — edited Mar 14 2018

I would like to calculate the difference between two members which are of Date data type. When i use function @DateDiff the value is 0. The members date format is DD/MM/YYYY.

Is the date format in this function should be DDMONTHYYYY(Ex:13Mar2018) or we can give any date format?

If we can give any date format, please give an example to calculate the difference between two dates using @DateDiff or any other function.

Thanks in advance.
This post has been answered by JohnGoodwin on Mar 13 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2018
Added on Mar 12 2018
#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting
10 comments
649 views