We can handle the future dates from the view as below.
1) Create a calculated field using the following syntax.
Name: Dates - till today
if [Order Date] <= today() then [Order Date] end
2) Drag the [Dates - till today] on to the view ( Work Area).
3) Drag the [Dates - till today] on to Filter Shelf, select "Relative Date" then select "Special Tab" then select "non-null Values".
4) Now report does not show future dates.
No comments :
Post a Comment