Retrieve yesterday date data

[Former Member]

Hi all,

Please let me know how to retrieve yesterday date data. I have a field called CPUDATE. Now I wanna retrieve data until yesterday. How should I do? I just know how to retrieve data until today date

SELECT * FROM "PRD"."GMH" WHERE ( "CPUDATE" <= date(now()))

I tried to put now()-1 but it doesn't work.

Please help..

Thanks

Selvy

[lbreddemann · Accepted solution]

>

> Hi all,

>

> Please let me know how to retrieve yesterday date data. I have a field called CPUDATE. Now I wanna retrieve data until yesterday. How should I do? I just know how to retrieve data until today date

>

> SELECT * FROM "PRD"."GMH" WHERE ( "CPUDATE" <= date(now()))

>

> I tried to put now()-1 but it doesn't work.

You may want to check the documentation for date function [adddate/subdate|http://maxdb.sap.com/doc/7_6/ac/bdceebbb4a11d2a97100a0c9449261/content.htm].

Your statement should work when written somewhat like this:

SELECT * FROM "PRD"."GMH" WHERE   "CPUDATE" <= datesub(now(),1)

regards,

Lars

[Former Member · Accepted solution]

Thanks a lot all for helping me solving my problem.

SELECT * FROM "PRD"."GMH" WHERE "CPUDATE" <= subdate(now(),1)

My rate for you guys.

Thanks

Selvy

[Former Member]

Hi,

in open SQL it would work like this..

NEW_DATE = CPU_DATE - 1.
SELECT * FROM <DBTAB> INTO CORRESPONDING FILEDS OF <ITAB> WHERE <DATE> LE NEW_DATE.

Regards,

Rajesh Narkhede.