SAS Programming

DATA Step, Macro, Functions and more

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Quartz | Level 8

Calculate next Friday of a column date

It appears if it is a Friday then it will return next Friday.

E.g. 1 May 2020 then 8 May 2020.

Is it possible to return 1 May 2020 instead?

This is the current code: reportwk = intnx('week.6',today(),1,'b');

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Jade | Level 19

Posted 05-04-2020 09:22 AM (1794 views) | In reply to ywon111

Hi, @ywon111: Use this instead:

reportwk = intnx('week.7',today(),0,'e');

2 REPLIES 2

Diamond | Level 26

Posted 05-04-2020 08:33 AM (1836 views) | In reply to ywon111

reportwk = intnx('week.6',today(),0,'b');

--
Paige Miller

Jade | Level 19

Posted 05-04-2020 09:22 AM (1795 views) | In reply to ywon111

Hi, @ywon111: Use this instead:

reportwk = intnx('week.7',today(),0,'e');