neilkidds
24th February 2009, 04:39
I wanna update a specified field (UTC type) with current system time.
Function dte$() returns a string type value and funciton utc.num() returns a long type value.
Could someone tell me which function I can use?
NirajKakodkar
24th February 2009, 07:24
Hello ,
ERP LN provides time-zone independent date and time support. The user interface always shows local dates and times. Internally, however, Infor ERP LN stores dates and times in Universal Coordinated Time (UTC). It stores both date and time in a single long integer referred to as the UTC long format. This integer represents the number of seconds since 0:00 hour, January 1, 1970 (in UTC). The use of a long integer imposes an upper date limit of 2038.
So even though the table field stores the date/time in long format , the UI wether forms or Reports will always show local date/time format .
If you want to store only the current time , use time.num()
but still while you see the record in the table , it will appear in long utc format .
Regards,
Niraj