Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Date Difference in TWO DATES IN WEBI

Hello friends , I have a requirement to have the number of days between the dates. but when I calculate the formula in WEBI

DaysBetween([Sale Date]; [Invoice Date])

this does not work when i hit ok it says date format is invalid

I checked in universe by default sale date object and invoice date object is of type "character" if i change to date then report does not work at all.

please suggest how do I put the code in WEBI so it works to calculate the difference

2. Also if one date is "Not Assigned then it should take current date or give the output 0

thanks

soniya

Former Member
Former Member replied

Hi,

Make sure that the dates are in accpetable date format and date data types.

Hope this helps

Jacques

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question