ToDate returning #ERROR

[former_member1325728]

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 ..

[AlexGourdet]

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

[ayman_salem · Accepted solution]

use the following formula:

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

then format it to whatever date format you want

[former_member1325728]

Thank you ! it worked 🙂