Formula tool: if older than 60 days from last day of the prior month

[Elena_B1]

Hello.

Could you please help to complete the expression? If today is October 10, 2022, I need to find all docs that are 60 days older than September 30, 2022.

IF !IsEmpty([Clearing Document]) THEN "Settled" 

ELSEIF IsEmpty([Clearing Document]) AND [Posting Date] older than 60 days calculated from the last day of prior month

ELSE "Waiting for settlement" ENDIF

Thank you

[Felipe_Ribeir0 · Accepted solution]

Hi @Elena_B1 

Take a look at the attached workflow.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.