Relative Date Filter Question

[Tessa_Gable]

I've been trying to create a custom filter criteria that will return records that have an activity date less than the last 60 days, or an activity date of null.

I expect to see this but all I'm getting is the nulls

Invoice      Last Activity      Workflow run time
AA             2019-04-19      2019-08-21
BB             2019-05-21      2019-08-21
CC            (Null)                2019-08-21
EE            (Null)                2019-08-21
FF            (Null)                2019-08-21

Any help would be greatly appreciated.

[lmorrell · Accepted solution]

Hi @Tessa_Gable 

These date filters can get pretty confusing! However, by subtracting 60 days from fWorkflow (To give us the lower limit of your cut off) and then specifying that the last activity is greater than this date your filter will act as intended. This can be done by putting the formula below into your filter.

Datetimeadd([fWorkflowDate],-60,'days') >= [Last Activity]  OR IsNull([Last Activity])

If you wanted to recreate this filter without creating a column, you can use the below:

Datetimeadd(datetimenow(),-60,'days') >= [Last Activity]  OR IsNull([Last Activity])

The updated workflow is attached.

Hope this helps

[Tessa_Gable]

Awesome, it worked...Thanks so much.