topic Re: Datevalue function in SAP in Application Development and Automation Discussions

Datevalue function in SAP

Former Member — Wed, 24 May 2017 06:02:49 GMT

Hi All,

I want to find date value for particular date(ex 01/01/2014 = 41640 as in excel).

Is there any FM in SAP to find date value for a particular date.

Thanks in advance.

Re: Datevalue function in SAP

RaymondGiuseppi — Wed, 24 May 2017 06:27:39 GMT

What's your purpose? Nevertheless just MOVE the date field to an integer field.

(Conversion Rules for Elementary Data Objects → Date/Time Fields as Source Fields → Source Field Type)

Re: Datevalue function in SAP

Former Member — Wed, 24 May 2017 06:57:24 GMT

Thanks Raymond. Actually i am trying to find average between 2 dates (between 01.01.2014 & 01.04.2017).

Thanks.

Re: Datevalue function in SAP

retired_member — Wed, 24 May 2017 07:06:13 GMT

https://help.sap.com/http.svc/rc/abapdocu_751_index_htm/7.51/en-US/index.htm?file=abendate_time_processing.htm

Re: Datevalue function in SAP

RaymondGiuseppi — Wed, 24 May 2017 07:12:22 GMT

Use the implicit conversion from date to integer like when the Abaper add or subtract some integer to a date.

date3 = date1 + ( date2 - date1 ) / 2 .

Re: Datevalue function in SAP

Former Member — Wed, 24 May 2017 09:04:19 GMT

What's wrong with SD_DATETIME_DIFFERENCE and in any case what do you mean by 'Average between 2 dates'. The average what ??? If you really want what you state it is 1 day.

Re: Datevalue function in SAP

RaymondGiuseppi — Wed, 24 May 2017 09:20:08 GMT

Isn't technically a "date" a quantity, the "duration since an initial calendar date", so the average value of two dates can make sense?

Of course expressions like center/middle of range/interval and other ones could have been used 😉

Actually following syntax is also ok in Abap...

date3 = ( date1 + date2 ) / 2.

Re: Datevalue function in SAP

RaymondGiuseppi — Wed, 24 May 2017 09:35:11 GMT

Like electromagnetism (wave/particle ) dates in abap carry some duality (character/numeric)

Re: Datevalue function in SAP

Former Member — Wed, 24 May 2017 12:16:31 GMT

So what happens when you run a 'Delayed Choice' experiment and turn the detectors on ? Are they then dates or characters or numeric ???

Re: Datevalue function in SAP

pokrakam — Wed, 24 May 2017 12:46:09 GMT

Isn't it more like Schroedinger's Cat? The day just is; it is the act of observation that reveals their format. If observed on a computer, they are numeric. Printed and hanging on a wall they are clearly character-based and not suitable for programmatic calculations.

Then there are also the more specialist date formats such as Lego and Stone, not sure if SAP will support those in future versions, maybe if we petition them enough...?

Re: Datevalue function in SAP

retired_member — Wed, 24 May 2017 12:58:02 GMT

I studied physics and document ABAP now. That fits.