cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
anagham
‎03-05-2020
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Need yesterdays date in format yyyy-mm-dd along with single quotes...

by Calcite | Level 5 in SAS Programming
‎03-05-2020 12:22 AM
‎03-05-2020 12:22 AM
Thank you all for the help..It was helpful. 🙂 I will share my code which worked properly in my case.   Thanks. ... View more

Need yesterdays date in format yyyy-mm-dd along with single quotes e.g...

by Calcite | Level 5 in SAS Programming
‎03-02-2020 05:28 AM
‎03-02-2020 05:28 AM
Hi,   I need yesterdays date in format yyyy-mm-dd along with single quotes e.g. '2020-02-28'.  Also, it should exclude saturday sunday. So if I am running job on Monday, it should take friday's date as input.   I have tried multiple things. I am getting correct yesterdays date with below(not included sat-sun logic yet), but I need single quotes along with it.   %sysfunc(PUTN(%eval(%sysfunc(date())-1),yymmdd10.))   Please help.   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-05-2020 03:43 AM
Quick links