Copying data from Sheets into a Database - Date & Time column doesn't work

[TedM]

Sorry if this has been done before...
I'm giving Appsheet Database a try as I rather like some of the views (which might work well for one of my clients).

I created the database by copying a [sheets] table to a new source and everything worked fine.

But when I then copied some new rows from the spreadsheet and pasted them into the database the data in Date & Time column in the spreadsheet would not go into the Date & Time column in the database as it didn't end with AM or PM.

Bug or am I doing something wrong?

(I've set up an action to enter the same data into the database when a new row is created in the spreadsheet - I'm not sure if that will work)

[SkrOYC]

You would be better away from AppSheet Databases while the test run is not done

[Marc_Dillon]

Appsheet database likely needs a certain formatting for any date/time/datetime values. So you'd need to change the format before copy-pasting.

[TedM]

OK, thanks.

[Steve]

AppSheet Databases is in preview and is not suitable for use in any important app.

Please report AppSheet Database problems here:

Introducing new AppSheet database feature in publi... - Google Cloud Community