Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Oct 18, 2021 05:44 AM
Hi,
I need help from your brain because mine is out for this problem !
Actually i have this formula :
IF(IS_SAME({Date d’envoi}, TODAY(), ‘day’), ‘YES’)
To this formule i want to add 2 things :
if the date is after today add “AFTER”
if the date is before today add “BEFORE”
Finally, i need to have 3 conditions :
YES if today
AFTER if the date is after today
BEFORE if the date is before today
Thank’s for your help !
Matthieu
Oct 18, 2021 09:02 AM
IF(IS_SAME({Date d’envoi}, TODAY(), 'day'), 'YES',
IF({Date d’envoi} > TODAY(), 'AFTER',
IF({Date d’envoi} < TODAY(), 'BEFORE')))