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

abhisek · ‎06-21-2023

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 · ‎06-21-2023

Hi @abhisek ,

We are going to need to know a bit more about your usecase, in order to help you.

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

abhisek · ‎06-21-2023

Hi @Peter Bodelier ,

I have updated the description.

Thanks in advance.

Regards,

Abhisek

Peter Bodelier · ‎06-21-2023

Thank you Abishek,

So if I understand you correctly, you have table, with data and a scheduled report that sends out reports based on that data?

If so, I would create a scheduled flow, which runs right before the scheduled report.
Look up all records in the table, and then based on your conditions set field E with the correct choice.

Shouldn't need any scripting at all.

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

abhisek · ‎06-21-2023

They want the changes on form level.

Thank you Peter.