data load

[HAmzehAF]

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 

[Aditya_Chitale]

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