on 10-16-2008 10:45 PM
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
Hi,
Make sure that the dates are in accpetable date format and date data types.
Hope this helps
Jacques
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Soniya,
Can you try this
Daysbetween(To_date(Sale_date);To_date(Invoice_date))
Regards
Prashant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Friends as you suggested I put this formula in WEBI but its not working its giving the value#error
=DaysBetween(ToDate([Delivery date]; "DD/MM/YYYY");ToDate([Goods issue]; "DD/MM/YYYY"))
Also I tried the below by swap the code
=DaysBetween(ToDate([Goods issue]; "DD/MM/YYYY");ToDate([Delivery date]; "DD/MM/YYYY"))
I have goods issue date in Right colum and Delivery date in Left
27.05.2008 14.12.2007
Please help me resolve this error
soniya
Hi ,
The above formula would have worked but as you have the Date as 25.07.2009 you have a Dot and the object is a charecter hence you need to do this
replace (<goods issue>,".","")
then use this
=DaysBetween(ToDate(Goods issue; "DD/MM/YYYY");ToDate(Delivery date; "DD/MM/YYYY"))
Hope this would help you.
Regards
Prashant
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.