2,129
Hello Experts,
I have a display method under table CustInvoiceJour.
In method I used code like below:
utcDateTime Timestamp; str Timestamp1; Timestamp=this.createdDateTime; Timestamp1=datetime2str(Timestamp);
and finally added Timestamp1 to QR code.When I check entry in under Inquiry form like below Date and Time is correct.
But in QR code information Date is correct but Time is not correct.
Thanks,
Faiz
I don't think you really want to hard-code the timezone in code. Most likely, you want the timezone configured for the current user:
DateTimeUtil::applyTimeZoneOffset(timestamp, DateTimeUtil::getUserPreferredTimeZone()));
Alternatively you might want the timezone of the current company.
Hi Martin,
Sorry I did not know before. How to apply like
utcDateTime Timestamp, Timestamp2; str Timestamp1; Timestamp=this.createdDateTime; Timestamp2= DateTimeUtil::applyTimeZoneOffset(Timestamp,UTC 03:00); Timestamp1=datetime2str(Timestamp2);
Please guide me if you do not mind.
Thanks,
Faiz
You forgot to apply user's timezone.
Datetime values are stored in UTC in database. They're automatically convert to user's timezone in forms, but it's your responsibility in your code.
Use DateTimeUtil::applyTimeZoneOffset().
#1
André Arnaud de Cal...
293,099
Super User 2025 Season 1
#2
Martin Dráb
231,884
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
