Date Time

Pick dates and times

The date time component displays an editable date and time field - allowing your users to edit dates & times within your app.

The date & time they choose will flow back up to your Sheet, so before you use it, make sure you have a dedicated column for these choices to flow into and connect the component to that column.

Configuring the date time component correctly

If you connect the wrong column, the choices users pick in the app could overwrite your existing data

What happens when you connect your date/time picker to the wrong column

Date formats and locales

At the moment, you can't change the way the date format is presented to users of the app. This gets chosen automatically by their device's location. However, you can change how it appears to you as you build your app.

Different locations in the world use different date formats. For example:

In the US, dates are formatted as: mm/dd/yyyy In the UK, dates are formatted as: dd/mm/yyyy

Glide and Google Sheets will work out where you are and use that formatting.

Sometimes if you're working in different locations you may run into issues with either Glide or Google sheets being in the wrong format. You can change the primary location of each and affect the resulting formatting of dates.

Changing your Google Sheet locale

In Google Sheets you can change the locale by heading to file/spreadsheet-settings. When you change

Changing the locale of your sheet

Changing your browser's locale

Glide's date picker recognises where you are and chooses the date format accordingly. We don't recommend changing your browser's language settings unless you're confident with what you're doing, but if you really need to get a different format in Glide then you can.

​

​