Evaluate Date type in RTC

julkifli33

hi all i have code like this

//Invoice Date
EBuf.RESET;
EBuf.SETRANGE(EBuf."Row No.",RecNo);
EBuf.SETRANGE(EBuf."Column No.",7);
IF EBuf.FIND('-') THEN
EVALUATE(InvoiceDate,EBuf."Cell Value as Text");

it works fine in classic
but when i test it in RTC there is an error message
01/03/2012 12:00 AM is not a valid date

i think it's because 12:00 AM
how to remove it ?
thanks

stevedivimast

I got the same error last week
Use a Datetime variable in evaluate instruction instead of Date type, then use c/al function to get the date.

julkifli33

stevedivimast wrote:

I got the same error last week
Use a Datetime variable in evaluate instruction instead of Date type, then use c/al function to get the date.

then how do i insert it to date type
let's say i have posting date in sales header
it can be inserted.... because date and datetime is different

stevedivimast

Change your code like this (InvoiceDateTime is a DateTime type)


EBuf.RESET;
EBuf.SETRANGE(EBuf."Row No.",RecNo);
EBuf.SETRANGE(EBuf."Column No.",7);
IF EBuf.FIND('-') THEN
EVALUATE(InvoiceDateTime,EBuf."Cell Value as Text");
InvoiceDate := DT2DATE(InvoiceDateTime);

julkifli33

stevedivimast wrote:

Change your code like this (InvoiceDateTime is a DateTime type)


EBuf.RESET;
EBuf.SETRANGE(EBuf."Row No.",RecNo);
EBuf.SETRANGE(EBuf."Column No.",7);
IF EBuf.FIND('-') THEN
EVALUATE(InvoiceDateTime,EBuf."Cell Value as Text");
InvoiceDate := DT2DATE(InvoiceDateTime);

hi stevedivimast
it works!
thanks a lot \:D/