Report filtering using calculated date fields

Question

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

Srinija_N · Accepted Answer

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!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded