Hello everyone,
I am tracking inspections and need to show January 1st of next year for the next inspection due date.
Example, if an inspection is completed today, 5/22/2024, then I need it to return 1/1/2025.
I have the below formula but it is returning nothing to the field which is causing the associated BOT to error. For reference, the purpose of this bot is to trigger an action to add a new row to another table. The action itself runs but doesn’t populate the [next_ispection_due_date] column. Since there is no value in that field, the BOT which is supposed to run that action automatically, errors because a value in that field is required.
Here’s the formula I’m trying to use.
date(concatenate((TEXT(TODAY(),“DDMM”),(“01/01”)),(year(today()+1))))
Any help you can give would be appreciated.
