Working with Date/DateTime in Database and Wappler

OS info

Problem description

In my database, I have multiple datetime fields in various tables. My issue is similar to that described in the topic, howto/dates-dynamic-dates-and-date-picker/5023, where my data is stored as 2018-10-17 21:09:30.

On my insert page, I utilize the date field and it submits the date properly. When I display the data on a page, I can format it and it appears in the standard MM/dd/yyyy format.

The issue is on the update page. When using the date form field, nothing is displayed. As indicated in the above post, I changed the field from date to text and the date is displayed in the format saved in the database, 2018-10-17 21:09:30.

While I can understand this format and update it as needed, my end users will not be able to.

I have looked and clicked on everything I can think of, but I can not see how to format the date on an update field to a MM/dd/yyyy format.

date1

Any assistance would greatly be appreciated.

Thanks

Community Page
Last updated: