Invalid Date running report in RTC

jimmyf

Hi
I have written a process only report which imports data from Excel and creates Gen jrnl lines. This was developed in Nav 2009 R2
The report has a Request Form and a Request page. When run from the classic client it works perfectly. However when I run from the RTC I get a date error..

'26/07/12 00:00' is not a valid date

There are no date fields in the request form or request page. The speadsheet contains a column for Document Date and Posting date and the values are both 26/07/2012

I do not understand why the RTC would Interpret the code in the report differently to the classic client.

All I am doing with the dates is

EVALUATE(TmpGenJnlLine."Document Date",ExcelBuf."Cell Value as Text");
EVALUATE(TmpGenJnlLine."Posting Date",ExcelBuf."Cell Value as Text");

GenJnlLine.VALIDATE("Posting Date",TmpGenJnlLine."Posting Date");
GenJnlLine.VALIDATE("Document Date",TmpGenJnlLine."Document Date");

Any advise would be appreciated

ta5

Do you have another settings for date and time format on the middle tier server?