## Finding Tuesday date

Solved
Occasional Contributor
Posts: 7

# Finding Tuesday date

Dear All,

Good morning ! I need to find tuesday date of the week dynamically.

For instance today date is 23-05-2018, when I run my code the date should be assigned to  22-05-2018

Another instance if run the code next week i.e 28-05-2018 , the date value should be assigned to 29-05-2018..

Accepted Solutions
Solution
a month ago
Super User
Posts: 23,293

## Re: Finding Tuesday date

INTNX().

Align it to the beginning of the week and then add 2. Check the docs for the details.

``Tuesday = intnx('week', today(), 0, 'b') + 2;``

@dhruvakumar wrote:

Dear All,

Good morning ! I need to find tuesday date of the week dynamically.

For instance today date is 23-05-2018, when I run my code the date should be assigned to  22-05-2018

Another instance if run the code next week i.e 28-05-2018 , the date value should be assigned to 29-05-2018..

All Replies
Solution
a month ago
Super User
Posts: 23,293

## Re: Finding Tuesday date

INTNX().

Align it to the beginning of the week and then add 2. Check the docs for the details.

``Tuesday = intnx('week', today(), 0, 'b') + 2;``

@dhruvakumar wrote:

Dear All,

Good morning ! I need to find tuesday date of the week dynamically.

For instance today date is 23-05-2018, when I run my code the date should be assigned to  22-05-2018

Another instance if run the code next week i.e 28-05-2018 , the date value should be assigned to 29-05-2018..

Occasional Contributor
Posts: 7

## Re: Finding Tuesday date

Dear Reeza,

Thank a lot.It working fine.
Posts: 5,481

## Re: Finding Tuesday date

This is reliably done with SAS date interval functions:

``````data test;
do date = '01may2018'd to '31may2018'd;
tuesday = intnx("day", intnx("week", date, 0), 2);
output;
end;
format date tuesday yymmdd10.;
run;

proc print data=test noobs; run;``````

i.e. find the date of the beginning of the week (a Sunday) and then move forward two days.

PG
☑ This topic is solved.