To get previous day from date function

mohitsaini · New User Joined: 15 May 2006 Posts: 92

Hi,

I am retrieving current system date from the following syntax in COBOL:

Accept ws-date from date.

Now my requirement is to get yesterday's date.

So can you please tell me on how to get that.

Any kind of help will be really appreciated.

- Mohit

CICS Guy · Posted: Tue Sep 18, 2007 2:55 pm

Easiest would be to subtract one from INTEGER-OF-DATE of the current date followed by DATE-OF-INTEGER....

kgumraj2 · New User Joined: 01 Aug 2007 Posts: 42 Location: Hyderabad

Hi,

If you use, db2 use
EXEC SQL
SELECT ( CURRENT DATE -1 DAY)
INTO :<wS-VAR>
FROM SYSIBM.SYSDUMMY1
END-EXEC.

snehalpatel · New User Joined: 13 Sep 2007 Posts: 37 Location: India

kgumraj2 · New User Joined: 01 Aug 2007 Posts: 42 Location: Hyderabad

Hi,
Please find following code that might be of some use.

mohitsaini · New User Joined: 15 May 2006 Posts: 92

Thanks all for all the inputs.

balakrishna reddy · Posted: Fri Sep 21, 2007 3:13 pm

Hi All,

I have one doubt,If you subtract one from date integer up to 2 of the month it will be okay, If it is 1st of month then if you subtract 1 from date it will becomes zero then your logic will not work.

we have take care of the year, month and the date integer too.

guptae · Posted: Fri Sep 21, 2007 4:58 pm

Hi Bala,