Date formula

[miki2024]

Hi there,

I'm going to run a new campaign to reward new members who join the club for 9 months. 

In our customer database, we have customers' join date data (in date format: YYYY-MM-DD).

I wonder what goes wrong with my following formula

If DateTimeDiff([Club Entry Date],DateTimeToday(),"month")<=9 THEN "Y" ELSE "N" ENDIF

Thanks!

[ShankerV · Accepted solution]

Hi @miki2024 

Please use the below, just interchanged the dates in your formula.

If DateTimeDiff(DateTimeToday(),[Club Entry Date],"month")<=9 THEN "Y" ELSE "N" ENDIF

Many thanks

Shanker V