Date is not valid

brijleo

Hi,

we are trying to import data from excel to navision using process only report.
when we run this report in Classic Client, it import the data successfully, but when we run the same report from RTC it gives me error " The date is not valid".
When I comment the code written for date field in the report, it import the data successfully through RTC also.
Excel store date in the following format: 01/06/2011 (dd/mm/yyyy).
Can any body help me out, why it is happening in the RTC. we are using NAV 2009 R2 in 3-teir environment.

Thanks!

Alex_Chow

RTC cannot handle non-ascii characters. You have to make sure your data is extremely "clean".

brijleo

Hi Alex,

Thanks for your help, Its working now. =D>

Alex_Chow

You're welcome! Please mark the topic as solved.