In the database the following dates display in the record for an appointment:
Table: ser_amelia_appointments
However, when I locate the SAME record in AMELIA front end the date is correct but the TIME is not. It displays the CORRECT datetime on the front end but in the database the TIME component is way off.
I am silly I figured out the date/time in the database is stored in UTC format but the front end is set to display in the correct local time format. ie Australia etc. That was the issue I simply converted over from UTC to local time and all is good.
In the database the following dates display in the record for an appointment:
Table: ser_amelia_appointments
However, when I locate the SAME record in AMELIA front end the date is correct but the TIME is not. It displays the CORRECT datetime on the front end but in the database the TIME component is way off.
Hey everyone
I am silly I figured out the date/time in the database is stored in UTC format but the front end is set to display in the correct local time format. ie Australia etc. That was the issue I simply converted over from UTC to local time and all is good.
Hello Martin,
We are glad that everything has been sorted out. If you have any more questions please open another ticket and we will gladly help you there.
We wish you all the best.
Kind Regards,
Marko Davidovic [email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, floor plans, choropleth maps, and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables