Using dynamic date to update field value

[Ashmita_P]

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.

[fmvizcaino · Accepted solution]

Hi @Ashmita_P ,

The idea was to create a dynamic date field with dynamic year as well. 

Best,

Fernando Vizcaino