I seem to be having a moment… I can’t get my head around this calculation, wondering if someone could help?
I’m creating a entry in my Listing table, one of the columns is called “Expiry Date” and it’s always set to be 1 month ahead of the currentDateTime when the record is created, so - Current date/time +(months): 1
I’m trying to figure out how I can return a bunch of records in a search that are coming up to the Expiry Date, a week before to be precise but I can’t figure out how to do it. It’s going to be something like the below I’m sure.
I wanted to send the list of records which are due to expire (a week before) to a scheduled API so an email could be sent to each Creator. Can anyone help with the date/time formula?