Yesterdays Date

[Fleroo]

Hello,  you folks helped me out immensely with figuring out how to turn the date of 1/1/1960 into a real date to be stored in an Oracle table.  I have another question on how to turn that date, which is the CURRENT date, into the PREVIOUS days date.  The following is the code.

*  This gets the current Date.

%let curday=%sysfunc(date(), date9.);

%put &curday;

* This loads the records into an Oracle table.  the date portion  hos_date is the date 7/25/2013 12:01:01 PM.  I want it to be Yesterday's Date of 7/24/2013 12:01:01 PM

proc sql;
insert into safety.safety_hrs_svc

select dhms("&curday"d,12,01,01) as hos_date, STATION, CONTR_ID, CONTR_NAME, PRIM_SVC_AREA_ID, DRIVER_NBR, DRIVER_NAME, PCK_DELV_HRS, SPOT_HRS, LINEHAUL_HRS from work.safety_hrs;
quit;

Thank you very much.

[OS2Rules]

Try:

%let preday=%sysfunc(date()-1, date9.);

[Fleroo]

OS2, that generates the following error..... cut from the log.

11         %let prevday=%sysfunc(date()-1, date9.);

ERROR: Expected close parenthesis after macro function invocation not found.

Thanks so much for looking.

[OS2Rules]

My Bad:

use:

CALL SYMPUT('predte',put(date()-1.date9.));

[BrunoMueller]

Fleroo

Check this code:

%let curday=%sysfunc(PUTN(%eval(%sysfunc(date()) - 1), date9.));
%put NOTE: &=curday;

[Fleroo · Accepted solution]

Bruno......... BANG.  YOU NAILED  IT.  Man you're good.   Do you want to fly to Pennsylvania ?   :smileylaugh:

THANKS ALL.... I LUV THIS BOARD

[Haikuo]

You can also use INTNX:

%let curday=%sysfunc(intnx(day,%sysfunc(date()), -1),date9.);

%put NOTE: &=curday;

Haikuo