Expiry Date Calculation

Need help Database
1

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?

image
image.png419×535 13.4 KB

2

To answer my own question, I think I figured it out…
image

2 Likes
3

For future reference if you want to take 7 days off a date …

+(days): -7

1 Like
4

Thanks Nigel, I forgot to update it, that’s what I did after a bit of playing around.