I am using date filer in my report as :date=(current date,-14)and (current date) where my date is in the form of 2004-10-21 00:00:00.000 format.It is giving me an error.Please help
Please see the date format.
I have also tried this but not successful,basically i want to fetch revenue of last 14 days.
[Date]= trunc(_add_days(current_date,-14)) and trunc(current_date)
try to use cast function before you apply filters.
Cast([Date],date)=(_add_days(cast(current_date,Date),-14))
Sounds like you should be using the "between" operator. It checks whether a value lies within a range of values.
E.g.
Cast( [Date], date ) between _add_days( current_date, -13 ) and current_date