about date

Greetings from Nepal to all the experts,

When I close my database it gives me an error message like “Date is not valid”. what is the reason and what should I do to solve this problem.

Please suggest!

Thanks in advance!

Sangam Shrestha

Nepal

Is it version 4? Have you set the time register flag on the user? Unselecting it removes the date - this was a known issue back in the day, so it depends upon your version!

HI

How many companies there in the data base ?

work date should be same for each company

if work date is not same then then the system will pop up an error message

Thanks

Jerome marshal.J

I was facing same problem

Sangam please change your code of Report No 81 as: this error is due to the date time error.

CODE BEFORE…

ExcelBuf.“Row No.” = HeaderRowNo:

BEGIN

TempExcelBuf := ExcelBuf;

TimePos := STRPOS(TempExcelBuf.“Cell Value as Text”,’ 00:00’); // Time part - only on Service Tier

IF TimePos = STRLEN(TempExcelBuf.“Cell Value as Text”) - 5 THEN

TempExcelBuf.“Cell Value as Text” := COPYSTR(TempExcelBuf.“Cell Value as Text”,1,TimePos - 1);

CASE TRUE OF

TempDim.FIND(’-’):

CODE AFTER…

ExcelBuf.“Row No.” = HeaderRowNo:

BEGIN

TempExcelBuf := ExcelBuf;

CASE TRUE OF

TempDim.FIND(’-’):

CODE BEFORE…

EVALUATE(TestDate,TempExcelBuf.“Cell Value as Text”):

BEGIN

TempExcelBuf.Comment := Text014;

TempExcelBuf.INSERT;

END;

CODE AFTER…

EVALUATE(TestDateTime,TempExcelBuf.“Cell Value as Text”):

BEGIN

TempExcelBuf.“Cell Value as Text” := FORMAT(DT2DATE(TestDateTime));

TempExcelBuf.Comment := Text014;

TempExcelBuf.INSERT;

END;

Tulasi (Nepal) :slight_smile:

one thing i missed here is:

TestDateTime is datetime variable not the date variable. Just delete Testdate and Timepos

adam what are the effect if I untick the time register will we not be able to monitor time register of the user?