Calculating the Days between two dates

Hi All,

I need to compare the Bill Date of the material to the date that is entered by the user using which i captured using UserResponse(). For the user to enter the date, i am using the Calendar Day Dimension in filters pane. Now wen i am trying to calculate the Days between the two dates using the DatesBetween() it is saying that there is no data to retrieve.

I guess this is because i am trying to use the Calendar Day dimension to filter the data.

Please Help,

Thanks & Regards,

NRR