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 ?