topic Re: function between 2 dates in Application Development and Automation Discussions

function between 2 dates

Former Member — Tue, 22 Nov 2005 16:33:18 GMT

i have 2 dates from table "date1" "date2".

i want that date3 will get the biggest date between the two, and if both of them are null he will get a value

that i tell him.

Re: function between 2 dates

Former Member — Tue, 22 Nov 2005 16:39:53 GMT

if date1 is initial and 
   date2 is initial.
*-- set default value
   date3 = <default value>.
elseif date1 > date2.
  date3 = date1
else.
  date3 = date2.
endif.

Re: function between 2 dates

Former Member — Tue, 22 Nov 2005 16:40:27 GMT

i'm looking for function

thanks

Re: function between 2 dates

Former Member — Tue, 22 Nov 2005 16:40:38 GMT

Hi,

if not date1 is initial and

not date2 is initial.

if date1 gt date2

date3 = date1 - 1.

else.

date3 = date2 - 1.

endif.

else.

tell me something for date3

endif.

regards matt

Re: function between 2 dates

Former Member — Tue, 22 Nov 2005 16:41:32 GMT

Hi,

data: date1 type sy-datum,

date2 type sy-datum,

date3 type sy-datum.

date1 = sy-datum.

date2 = sy-datum + 1.

if date1 gt date2.

date3 = date1 .

else.

date3 = date2 .

endif.

Regards

vijay

Re: function between 2 dates

Former Member — Tue, 22 Nov 2005 16:41:43 GMT

By comparing both dates you can get which is bigger.

Re: function between 2 dates

Former Member — Tue, 22 Nov 2005 16:42:09 GMT

> i'm looking for function

> thanks

I don't think there is any function module to do that.

Re: function between 2 dates

Former Member — Tue, 22 Nov 2005 16:46:01 GMT

There is no existing FM to do this. Its a simple comparision that it does not warrant a seperate Funtion module. But if you need one, you can always create a new function module and put in Srinivas's or Vijay's code in it.

Re: function between 2 dates

RichHeilman — Tue, 22 Nov 2005 16:46:20 GMT

If you prefer to have a function, you can use the code provided above and create your own function module.

Regards,

Rich Heilman

Re: function between 2 dates

Former Member — Tue, 22 Nov 2005 16:46:44 GMT

I would go on with Srinivas this is to "simple" to capture it in a function...

and the issue was "biggest date between" thats why I used -1 to get the day before...

Re: function between 2 dates

Former Member — Tue, 22 Nov 2005 16:51:04 GMT

If you are looking for a Fuction Module, try RELATION_BETWEEN_TWO_DATES