select last 3 days in the past .

[wanass123]

select yesterday I used below code :  

if(Problem_Resolution_Date=date(today()-1),'Yes','No') as resulutionYestarday,

select day before 4 days ago I just change -1 with -4 

if(Problem_Resolution_Date=date(today()-4),'Yes','No') as resolvedlast4Days,

how to select last 3 days ( -1 , -2 , -3 ) or last 4 ( -1 , -2 ,-3 , -4 )  days .. ?

because above code give data for one day only, but what  I need is to select  a range 

please advice . 

[Chanty4u · Accepted solution]

SET vDateFlag = Date(Today() - 3);

IF(Date(DateField) >= $(vDateFlag), 'yes', 'no')

or in set analysis

Sum({< DateField = {'>=$(vDateFlag)'} >} Sales)