ToDate function does not work

[Former Member]

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 · Accepted solution]

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

[Former Member · Accepted solution]

Nimish,

Has the formula worked or you are still having issues with the conversion.

[Former Member]

SriHarsha,

Thank you for your response. Yes, this formula worked for me.