topic Re: time and date in Application Development and Automation Discussions

time and date

former_member611341 — Wed, 02 Aug 2006 13:42:25 GMT

Hello guys,

I have a date(07/26/2006) and time (17:07:46)fields.

I have to condition to check if it is crossed two days ( i.e 24 hrs ) how shud i add exactly 2 days (or 24 hrs ) to this this date and time field.

like shud i add 2 days to date? if so how?

or any other solution?

Re: time and date

Former Member — Wed, 02 Aug 2006 13:44:40 GMT

You can try this FM RP_CALC_DATE_IN_INTERVAL.

(it is workin tested...)

call function 'RP_CALC_DATE_IN_INTERVAL'

exporting

date = sy-datum

days = 3

months = 0

signum = '+'

years = 0

importing

calc_date = wa_date.

Re: time and date

Former Member — Wed, 02 Aug 2006 13:47:00 GMT

Yes, u can add '2' to the date variable u r having now. That will solve ur problem.

Re: time and date

RichHeilman — Wed, 02 Aug 2006 13:52:59 GMT

Aday, just add 2 to the date.

data: this_date type sy-datum.

this_date = sy-datum .

this_date = this_Date + 2.

To be clear, adding 2 days will add 48 hours, not 24.

Regards,

Rich Heilman

Re: time and date

Former Member — Wed, 02 Aug 2006 13:54:03 GMT

Hi Aday,

Just add 2 to date field and check for condition.

DATA V_DATE1 TYPE SY-DATUM VALUE '20062607'.

DATA V_TIME TYPE SY-UZEIT VALUE '170746'.

DATA V_DATE2 TYPE SY-DATUM.

V_DATE2 = V_DATE1 + 2.

IF V_DATE <= V_DATE2 AND V_TIME <= V_TIME1.

WRITE:/ 'DOESNT CROSS 2 DAYS'.

ELSE.

WRITE:/ 'CROSSED 2 DAYS'.

ENDIF.

Thanks,

Vinay

Re: time and date

former_member611341 — Wed, 02 Aug 2006 13:55:26 GMT

IF just add 2 to date ...in that case i have to check time...is it same or less or greater.

coz i need exactly 24 hrs added to date and time.....

Re: time and date

former_member611341 — Wed, 02 Aug 2006 13:56:55 GMT

thnks guys for all your quick responses....

Re: time and date

Former Member — Wed, 02 Aug 2006 14:17:48 GMT

Hi Aday,

If you specically want to add only hours then use this function module <b>CATT_ADD_TO_TIME</b>.

DATA V_DATE TYPE SY-DATUM VALUE '20060726'.

DATA V_TIME TYPE SY-UZEIT VALUE '170746'.

DATA V_DATE1 TYPE SY-DATUM VALUE '20060726'.

DATA V_TIME1 TYPE SY-UZEIT VALUE '170746'.

CALL FUNCTION 'CATT_ADD_TO_TIME'

EXPORTING

idate = V_DATE

itime = V_TIME

stdaz = '2400' -->Specify hours with minutes

IMPORTING

EDATE = V_DATE1

ETIME = V_TIME1.

WRITE:/ V_DATE1, V_TIME1. -->Will contain new date and time afte adding STDAZ hours with mintues.

Thanks,

Vinay

Re: time and date

former_member611341 — Wed, 02 Aug 2006 15:08:18 GMT

I have a tbale with some fields.

lets say 3 fields xxx ,date (07/26/2006 )

and time(17:07:46) .

i want to select xxx from table only if it is two days or more older.

that's what i need .

may be i shud have asked question clearly...

Re: time and date

Former Member — Wed, 02 Aug 2006 15:24:25 GMT

Hi Aday,

Try with this code.

DATA V_DATE TYPE SY-DATUM.

V_DATE = SY-DATUM - 2.

LOOP AT ITAB WHERE DATE >= V_DATE.

WRITE:/ ITAB-XXX.

You have XXX values so now code as per your need here

ENDLOOP.

Thanks,

Vinay