App Connect Data Formatter Support Product Page

Answered

What's wrong with this time format?

Asked 04 Apr 2017 10:53:46
2
have this question
04 Apr 2017 10:53:46 Firdaus Rohman posted:
Date from database = 2017-04-04 18:16:14
Date binded and formatted .formatDate("hh:mm a dd-MM-y" = 10:16 am 04-04-2017

I think the formatted time above should be = 06:16 pm ??

Replies

Replied 05 Apr 2017 09:40:01
05 Apr 2017 09:40:01 Teodor Kuduschiev replied:
Hello Firdaus,

The time returned is in UTC format, which appears to be causing issue with PHP. We changed that, so it returns the time in whatever format it is stored in the db. This will be included in the upcoming update.
Replied 05 Apr 2017 12:20:10
05 Apr 2017 12:20:10 Firdaus Rohman replied:
Ok for the time being, I add 8 hrs to the formatter. Will alert when there's update for it.
Replied 18 May 2017 20:48:05
18 May 2017 20:48:05 Brad Lawryk replied:
I need a fix for this as well. My formatted timestamps are showing 7 hours ahead. How can I subtract 7 hours in the formatter?

Reply to this topic