SAS - Visual Data Builder - where dynamic date condition

[dhavalyparikh]

In visual data builder expression date function while creating data query condition - where tab :

I want place conditions like 

Where start_date between intnx(week,start_date, 0,'B') and  intnx(week,start_date, 0,'E')

having said - I want to see a list of only those records where startdate is within the current week's first date of week and last date of week. 

[KeithM · Accepted solution]

The following is an example of the expression that you will need to use.  Note, in the example expression "date" is a data item.  You will have to have a value for your start_date.  I simply hard coded in may 30.

intnx('week','30MAY1980'd,0,'B') <= 'date'n <= intnx('week','30MAY1980'd,0,'E')

[dhavalyparikh]

That's great - I will try to implement it tomorrow and get back to you. Thank you very much.

[dhavalyparikh]

Instead of you hardcoded date as intnx('week','30MAY1980'd,0,'B') <= 'date'n <= intnx('week','30MAY1980'd,0,'E')
Is there way I can use the current date ? with my case statement

Start_Date is : (TableDate Value Field)
In below statement

select
ind_latest =
case when Freq="Weekly" and intnx ('Week',Today(),0'b') <= Start_Date<=intnx ('Week',Today(),0'E')
then 1
else 0
run;