Skip to Content

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

ToDate function does not work

Hi All,

I have a date field in my incoming data that has the following format: MM-DD-YYYY and is of String dataype.

I have another Date in my report that has the following format: mm/dd/yy and is of Date datatype.

I am trying to get the number of days between these 2 dates by using the DaysBetween function.

However, the first Date gives me an error:

"The expression of sub-expression at position 29 in the DaysBetween function uses an invalid data type. (IES 10037)"

This error is referrring to the data format of the first date and when i try to convert this date using ToDate function, I get a #Error on my report.

Can someone please help me how to fix this issue while trying to get the number of days between the 2 Date fields?

Any help is greatly appreciated.

Thanks

Former Member
Former Member replied

Nimish,

Whats the todate formula that you are using.

The formula that needs to be used is ToDate([FirstDate];"MM-dd-yyyy")

Regards

Sri Harsha

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