Unrecognized input 'HH' at position 59 (IES 10022) , why, for correct formula?

[former_member954596]

Not sure what's wrong with the formula, trying to get the difference in date/time in minutes, please help!!

=(ToNumber(SubStr(FormatDate([Bed Assigned Date Time] ,"HH:MM:SS") ,1 ,2))*60) + (ToNumber(SubStr(FormatDate([Bed Assigned Date Time] ,"HH:MM:SS"), 4, 2))) + (ToNumber(SubStr(FormatDate([Bed Assigned Date Time] ,"HH:MM:SS"), 7, 2))/60) - ((ToNumber(SubStr(FormatDate([Last Bed Requested Date Time] ,"HH:MM:SS") ,1 ,2))*60) + (ToNumber(SubStr(FormatDate([Last Bed Requested Date Time] ,"HH:MM:SS"), 4, 2))) +(ToNumber(SubStr(FormatDate([Last Bed Requested Date Time] ,"HH:MM:SS"), 7, 2))/60) +((DaysBetween([Bed Assigned Date Time];[Last Bed Requested Date Time])*24)*60)

[former_member751964]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend you to read this overview Community Q&A, and to take our Q&A tutorial. With these tips you'll be able to prepare questions that draw responses from our members.

The more details you provide, the more likely it is that members will be able to answer your question.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a Picture to your profile you encourage readers to respond.

[ayman_salem]

correct it to "HH:mm:ss"

and why you use this complex formula, just use TimeBetween

TimeBetween(first_date;last_date;period)

period: HourPeriod, MinutePeriod,SecondPeriod, MillisecondPeriod

[mgrackin]

I second Ayman's suggestion. Change the double 'MM' and double 'SS' to lowercase.

[former_member954596]

Thanks Michael, I tried this but getting a Invalid Identifier error message?

[former_member954596]

please see attached error. thanks

[ayman_salem]

If you have an old version of BI, this function is not available.

which version did you have?

[former_member954596]

©2010 - 2016 SAP SE or an SAP affiliate company. All rights reserved. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE in Germany and other countries. Please see http://www.sap.com/corporate-en/legal/copyright/index.epx#trademark for additional trademark information and notices.

SAP BusinessObjects BI Platform 4.2 Support Pack 2 Patch 12
Version: 14.2.2.2484

www.sap.com/bi ©2010 - 2016 SAP SE. All rights reserved.

[ayman_salem]

the TimeBetween function is not available in your SP2

If possible (which is recommended) update to the latest SP (current SP8-P1100 and SP9-P200) or use your complex formula and correct the format to "HH:mm:ss".