Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ToDate() function not working

I need to convert string to Date type and use it in the DaysBetween function.

Created a variable =ToDate("01/10/2010"; "dd/mm/yyyy").

The output for this becomes 01/01/2010.

What can I do to make the ToDate() function work?

Former Member

As already suggested, you have to use the format =ToDate("01/10/2010"; "dd/MM/yyyy") as mm stands for minutes.

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question