cancel
Showing results for 
Search instead for 
Did you mean: 

Filter Date field based on Formula

former_member225386
Participant
0 Kudos

Hi All,

Could anybody help me to filter the date field based on the below requirement,

1)User will select the End date and number of weeks like 26,52,2 year and 5 years:

Based on the above selection I need to calculate the start date and need to filter the date field based on Start date and End date.

Previously I used Parameter field to get both start date and end date then used the parameter field in report filter to filter the date field.

View Entire Topic
former_member225386
Participant
0 Kudos

Hi Raghav/Abhilash,

Thank you!

But the DateAdd('ww',-52,{?Date_Prompt}) returning date field requied error.

End_Date is in Date format and Week is in number format.

Please help me on this.

raghavendra_hullur
Active Contributor
0 Kudos

Hi,

Is your date prompt in date datatype or date time type?

If it's of date time type, use CDate on top of DateAdd function.

Use below code:

cDate(dateAdd('ww', -{?weeks}, {?Date}))

Thanks,

Raghavendra