[✅ Solution] Trouble with Dates

[ScottA]

I need help with creating a flow around dates… Specifically I need a flow that does the following:

1 - if today’s date falls between the rent start date and end date of a tenant’s rent term - a category in that same item should be marked as “Current” rent
2 - if today’s date is AFTER the rent end date - it should be marked as “Expired” rent
3 - if today’s date is BEFORE the start date - it should be marked as “Future” rent

This flow would need to look at these dates every day at midnight and recategorize items as needed.
I CANNOT figure this out. Help. Please. Thank you. - Scott

[Luis]

Hey @ScottA

The automation will look something like this:

I added the automation template to your workspace for you to test. Let me know if it works.

[ScottA]

OUTSTANDING!! Thank you Luis. I just finally got the chance to play with it. That is so helpful. Podio has been tripping over dates lately… and I’m having to go back and verify this stuff. SUPER annoying. I never expected you to DO it… but thank you again! Much appreciated. I’m going to keep playing with it.