Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Change hours to another value

Hi,

I have underlying bex datetime field (STRING)  [FinishTimstmp] which is in "dd.MM.yyyy hh:mm:ss" format...

I want to convert this field to a populate a new value where ever it finds date value from 16.09.2014 24:00:00 >> 16.09.2014 23:59:59.

I do get 2 values in that Bex field (STRING)- eg. 16.09.2014 00:00:00 or 16.09.2014 24:00:00.

When converting this STRING (date) field in webi by using TODATE() function webi interprets 16.09.2014 00:00:00 to 16.09.2014 12:00:00 and where it finds 16.09.2014 24:00:00 it throws an #ERROR.

I want to calculate the difference between this date field and with currentdatetime to give me the difference in HOURS.

Any clues ?

A.B.

Former Member
Not what you were looking for? View more on this topic or Ask a question