Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
how to fix this to take 30 days before for any date i pick in the sheet?
IF(Date = Date(Today() - 30), 1, 0) AS Is30DaysAgo,
this only take it for today and going back 30 days and if i pick a date from the sheet i get 0
if you want to go back 30 days on basis of selected date, try getfieldselections() instead of today()
=IF(Date = Date(getfieldselections() - 30), 1, 0)
Regards,
Aditya