Skip to Content
Former Member
Sep 16, 2014 at 08:43 AM

Change hours to another value



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 ?



dates.jpg (41.5 kB)