Hi community,
I am trying to have a field that says whether a record is post, pre or on a particular date.
However, I need the date to update autmoatically once it has been reached.
For example, my dates are
20 Mar, 20 June, 20 September and 20 December every year.
So if a record has a date of 12 May, and the model is run on 14 May, it should reflect as "Post date" (since it is after 20 Mar) .
But if it is run on 15 July, it should say "Pre date" (Since it has been run after 20 Jun). The filter parameter should be the most recent of those 4 dates. And there can be records from past years also.
Solved! Go to Solution.
Hi @Ashmita_P ,
The idea was to create a dynamic date field with dynamic year as well.
Best,
Fernando Vizcaino