Skip to main content

Topic: Calculated field with date values (Read 36 times) previous topic - next topic

  • 8

  • 0

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?

  • 113

  • 0

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.