Filtering Logic Question

[Joemac]

I'd like to filter based on records that are 14 days past the prod_complete_date field below.  Is there a way to do that within the set up below?  Not sure how to write that out.

[TellMeWhy]

You can't do that as it requires dynamic setting.

A workaround is, if you have an Application Task Feature, create a Date Field to store TimeStamp, create a Formula Field to DateDiff the prod date and TimeStamp Field

Set it to run every midnight

 

Then use the formula Field on the criteria instead...if Formula field > 14

[Flowers4Algernon]

Hey!

You may also check out his how-to link regarding Tasks: https://howto.caspio.com/tasks/