How can I check that a date field is updated before 5 months ago or less than 5 months ago ?

[abhisek]

There are total 5 fields on a report table, for example: A,B,C,D,E

D field is a date field. E field is a choice field having values like x, y and z and it is a read only field.

I have to set that E field value based on below conditions:

(1) x -> At least one of the field (A/B/C/D/E) is not completed or D the date field was updated before 5 months ago.

(2) y -> D the date field  was updated less than 5 months ago and all other 4 fields (A/B/C/E) are completed.

(3) z -> The scheduled report is Active = False

Can anyone please help me out ASAP as it is urgent.

[Peter Bodelier]

So they only want it updated when the form is opened, or should they also be able to query on that data?

[abhisek]

They want it every time whenever record is inserted or updated.

[Peter Bodelier]

Then the same could be done with a flow which triggers on insert or update on these records.

[Prateek kumar]

Try this: