Question Re: ToDate returning #ERROR in Technology Q&A

ToDate returning #ERROR

former_member1325728 — Thu, 16 Feb 2023 17:05:32 GMT

I have an issue converting string (2022-11-01T00:00:00) to a date using todate function. no matter how I defined the format I receive #ERROR message

Please help ..

Re: ToDate returning #ERROR

AlexGourdet — Thu, 16 Feb 2023 17:05:41 GMT

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

Profile https://developers.sap.com/tutorials/community-profile.html
Tips for Questions: https://community.sap.com/resources/questions-and-answers
Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

Alex

Re: ToDate returning #ERROR

ayman_salem — Thu, 16 Feb 2023 17:19:54 GMT

use the following formula:

v_ConvDate: =ToDate([DateToConvert]; "yyyy-MM-ddTHH:mm:ss")

then format it to whatever date format you want

Re: ToDate returning #ERROR

former_member1325728 — Wed, 22 Feb 2023 12:26:19 GMT

Thank you ! it worked 🙂