is there a way to do a CASE WHEN THIS AND THIS in ...
# suiteflow
p
is there a way to do a CASE WHEN THIS AND THIS in a saved search?
d
I did it like this and it seems working: CASE WHEN ROUND({custrecord_imp_stat_parent.trandate} - {today}) > 13 THEN 'Future' WHEN (ROUND({custrecord_imp_stat_parent.trandate} - {today}) <= 13 AND ROUND({custrecord_imp_stat_parent.trandate} - {today}) >= -1) THEN 'Present' ELSE 'Past' END
a
sure, just add AND between conditions
p
thanks. had the AND in the wrong spot.