Localisation issue ...

[jeffd2652]

I've just been trying to resolve an issue with the local settings for time zone and date format ... but can't seem to get the DB to respond.

I've set the time zone to Europe, Madrid and the date for mate to UK (day/month/year) but when I use the DB and try to amend an entry for instance ... the date ... the drop down calendar whilst showing the correct date (ie 3rd November 2019) when selected the data appears as 11/03.2019.

Is there a way to alter this behaviour as it's causing problems ???? Thanks

[Vitalikssssss]

Hi @jeffd2652,

Date&Time stored in Caspio table always use a US formatting and there is no way to change this setting.

You can use Localization in order to change the format how it appears in Datapages.  

Regards,

vitalikssssss

[SinJunYoung]

This link might be able to help as well: https://howto.caspio.com/tech-tips-and-articles/common-customizations/stamp-the-time-url-or-ip-address-to-new-and-updated-records/