topic Re: Comparing two date fields? in Application Development and Automation Discussions

Comparing two date fields?

Former Member — Wed, 19 Dec 2007 10:38:57 GMT

Hi SDN,

I have to date fields lv_d1 & lv_d2 i want to find out the comparision or difference between the above two fields.

regards,

Rahul

Re: Comparing two date fields?

Former Member — Wed, 19 Dec 2007 10:43:48 GMT

rahul,

data:

lv_int1 type i,

lv_int2 type i.

lv_int1 = lv_d1.

lv_int2 = lv_d2.

lv_int2 = lv_int2 - lv_int1.

wht evere comparision u want u can do basically wht happns is int variables will have the value of no of days so u can compare wht ever u want

plzz reward if u found my answer helpfull to u

Re: Comparing two date fields?

Former Member — Wed, 19 Dec 2007 10:48:37 GMT

Hi,

1. Difference:

lv_dt2 - lv_dt1 = <Number of days>

2. Comparison:

if lv_dt2 > lv_dt1 .

....lv_dt2 is latest date menas the condition will be true......

endif.

- Selva

Re: Comparing two date fields?

Former Member — Wed, 19 Dec 2007 10:49:16 GMT

hi,

use this fm /SDF/CMO_DATETIME_DIFFERENCE.

it will solve ur problem.

Reward points if helpful,

Regards,

Sumanjeet.

Re: Comparing two date fields?

Former Member — Wed, 19 Dec 2007 10:51:30 GMT

u havnt specified ..u want 2 compare 2 dates on wat basis..

den also use this FM HR_99S_INTERVAL_BETWEEN_DATES

to get da difference between 2 dates in days ,weeks and months...

let me knw if it is smthin else

Hope dis helps..

Reward if it does

Re: Comparing two date fields?

Former Member — Wed, 19 Dec 2007 10:56:50 GMT

Thanks for reply,

but i want the difference between 2 days should be greater than equal to 6 months.

how can i get the difference between two dates in months.

Regards,

Rahul

Re: Comparing two date fields?

Former Member — Wed, 19 Dec 2007 11:02:22 GMT

Hi,

Use the FM HR_HK_DIFF_BT_2_DATES. In oputput format put value as 04.

Thanks,

Lalit

Re: Comparing two date fields?

Former Member — Wed, 19 Dec 2007 11:07:16 GMT

hi,

you can use FIMA_DAYS_AND_MONTHS_AND_YEARS

Get number of days. Year, Months between two dates.

regards,

pavan

Re: Comparing two date fields?

Former Member — Wed, 19 Dec 2007 11:08:21 GMT

Hi Rahul,

Try any one of this function modules.

HRVE_GET_TIME_BETWEEN_DATES

CX_SCHED_VIA_OPERATING_TIME

SD_DATETIME_DIFFERENCE

SD_CALC_DURATION_FROM_DATETIME

HR_HK_DIFF_BT_2_DATES

Pllzzz Reward if useful,

Mahi.

Re: Comparing two date fields?

Former Member — Wed, 19 Dec 2007 11:10:06 GMT

Hi Rahul,

You can directly compare the 2 date fields.

eg... if di > d2.

else.

lv_diff = d2 - d1. You will get the value in no. of Days. You can divide this value by 30 to get the no. of months.

Lokesh