Date & Time Column

When you enter a date, a time or a date + time in your sheet, Google Sheets will recognize this format and automatically apply the right format to that cell. Read more here.

The Data Editor will also recognize this format and automatically assign a Date/Time Column type.

When the Data Editor recognizes a column as a date, a time or a date + time you get access to the Date/Time formatting settings.

This can be very useful if the dates & times in your sheet are in a different format to that which you want to display in your app.

Glide will still display your date and time in the app user's format (i.e. MM/DD/YY or DD/MM/YYY).