Help writing a filter

[TMC]

Hi all,

Not sure if this is the right approach: I am waning to filter records from out of Airtable. If the record is less than one month from the “Subscription End Date”

My Goal:
I have a base in Airtable with all my customer subscriptions and i want to draft an email them 1 month out, 2 weeks out and 1 week out as a reminder to renew there subscription

I asked the AI to write the formula for me but no joy. Chances are i am approaching this wrong so any advice/feedback is appreciated.

[Stoyan_Vatov]

Hey there,

is the End Date already a date type variable? If it is - then the format needs to be exactly the same to use the Datetime operators. So is it MMMM YYYY as well?

[TMC]

Thanks for the pointer, once i matched the format it worked perfectly. Thanks !