Skip to main content
Topic: Calculated field with date values (Read 47 times) previous topic - next topic

Calculated field with date values

I have a date filter. When i select a date in the filter, i want to display that day and the previous 2 days data.
Ex: If i select March 8, 2018 in the filter, I want to dispaly March8, March7 and march 6 data  on my worksheet.
Can someone please help me with this?

Re: Calculated field with date values

Reply #1
You can do this using a parameter for your date selection and then build a calculated field on your parameter and date field .

e.g.
[DueDate] <= [Select Date] AND [DueDate] > DATESUB ( [Select Date], 3, "DAY")
(Order date is your date field and select date is your parameter)

Then you can add that as a filter.