Hello I want to specify folder date in the program. I receive the data on Weekdays at night and run the program early next morning. So, the folder date is always like this: Processing data on Tue -------------- Date of Mon Processing data on Wed -------------- Date of Tue Processing data on Thur -------------- Date of Wed Processing data on Fri -------------- Date of Thu Processing data on Mon -------------- Date of Fri(Last) /*Facing problem in this one*/ I have written macro variable where it reads in the previous data dates. %LET FOLDER_NAME = %SYSFUNC(INTNX(WEEKDAY, %SYSFUNC(TODAY()),-1,E),YYMMDDN8.); So, If I process the data on 20170725, the folder date would be 20170724. But how should I include logic in this one for processing data on Monday. So, if the data is processed on monday of any given week, it should take in the date of last friday. Thanks Chandan Mishra
... View more