Report filtering using calculated date fields

[Rscofidio]

Hi,

I have a calculated field on a report that simply references a date field on the project level so that the information is available. It does not make any calculations of it's own.

Can I filter a report using that calculated field and a range of time?

When I try yo filter with that field I only get the following options:

Equal

Not Equal

Contains

Does not contain

Is Blank

Is not blank

I would like to have the report look at the field and show me the tasks that show a date range of today up to 3 months.

Any thoughts?

Thanks,

Robin

[Nijs_Gold_23 · Accepted solution]

Firstly, your calculated field should be of 'Date/Time' format on your form. Then You have to apply the range filter using the text mode on your calculated field as below.

DE:xyz=$$TODAY
DE:xyz_Mod=between
DE:xyz_Range=$$TODAY-3m

Hope this is what you are looking for!

Please mark my post as 'Correct Reply' if this helped you and also to help others.

Thanks! 

[Rscofidio]

Thanks!!! This did the trick!

So simple... If only I could reply with a face palm emoji.

I appreciate the quick reply.