Reduce date by a day in job control
Posted: Thu Jun 10, 2010 5:56 am
Hi All,
Kindly guide me for the below problem.
I need to substract a day from to date and carry the value for further processing.Pls help me out.
input format of date:
DATE_TO=18/02/2010
D1=Iconv(DATE_TO, "D2/")
D2=D1-1
TSTAMP1 = oconv(D2,"DDMY[2,2,4]")
DD = TSTAMP1[1,2]
MM = TSTAMP1[4,2]
YYYY = TSTAMP1[7,4]
FILEDATE = DDMMYYYY
Tried above but not getting the right value for FILEDATE.
FILEDATE EXPECTED:17022010
Thanks in Advance,
Harsha
Kindly guide me for the below problem.
I need to substract a day from to date and carry the value for further processing.Pls help me out.
input format of date:
DATE_TO=18/02/2010
D1=Iconv(DATE_TO, "D2/")
D2=D1-1
TSTAMP1 = oconv(D2,"DDMY[2,2,4]")
DD = TSTAMP1[1,2]
MM = TSTAMP1[4,2]
YYYY = TSTAMP1[7,4]
FILEDATE = DDMMYYYY
Tried above but not getting the right value for FILEDATE.
FILEDATE EXPECTED:17022010
Thanks in Advance,
Harsha