Skip to Content
0
Oct 24, 2011 at 07:48 AM

Webi Date Issue

61 Views

Hi All,

I am creating a Webi Report from an SAP Universe where in i have to calculate the Number of Days Between two dates, One of the Date is the Bill Date of Materials which comes from Universe and the other date will be entered by the User.

So i used the following Formula:

CP=UserResponse("Enter CP:")

Now i could get the date from the User's response, but it is coming in String Data Type and i am unable to compare it with the existing date. So i tried to change it into Date using the following formula:

Cmp Dte=ToDate([Cmp Prd];"dd.mm.yyyy")

The syntax is fine but i am having the following Error:

'#ERROR'

I am unbale to understand the problem...Please help,

Thanks & Regards,

NRR