topic Re: Problem with Date in Application Development and Automation Discussions

Problem with Date

Former Member — Tue, 17 Feb 2009 14:39:11 GMT

Hi guys,

I have date1 = sy-datum, which is stored as 20090217 (today's date).

Now, x is a variable which has for suppose '17' now.

In date2, i want to have value which is 17 days earlier, dat is '20090201'.

How can I write the code to fulfill my requiremnt, I havent worked on DATE fields earlier.

So, Iam getting confused.

I know I can find difference between two dates fields by simply subtracting them.

But, my requirement is different.

Waiting for ur suggestuions , guys......

Thanks,

Shivaa...

matt — Tue, 17 Feb 2009 14:40:41 GMT

date2 = date1 - x.

Easy, wasn't it.

Former Member — Tue, 17 Feb 2009 14:47:46 GMT

Thanks, man........i didnt think it was so easy........

Former Member — Tue, 17 Feb 2009 14:49:34 GMT

Former Member — Tue, 17 Feb 2009 14:56:37 GMT

Hi Shiva

Just Try FM:- HR_SGPBS_ADD_TIME_TO_DATE

Eg:-

DATA: L_DATE TYPE SY-DATUM.

CALL FUNCTION 'HR_SGPBS_ADD_TIME_TO_DATE'

EXPORTING

I_IDATE = SY-DATUM

I_TIME = '-16'

I_IPRKZ = 'D'

IMPORTING

O_IDATE = L_DATE

EXCEPTIONS

INVALID_PERIOD = 1

INVALID_ROUND_UP_RULE = 2

INTERNAL_ERROR = 3

OTHERS = 4.

Output:-

L_DATE = 20090201

Former Member — Tue, 17 Feb 2009 15:00:21 GMT

Thats good fm wonderful i will use it in future