# Date picker

**Date picker** controls are designed to capture dates with an intuitive user-friendly interface.

**Data type**: `date`

### Adding a Date picker control

1\. Edit your sheet\
2\. Click on the **Qommentary Form** extension\
3\. Expand **Input fields** section\
4\. Click on **Add input field**

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2Ffat9r1sCT4MHhobkvP7B%2Fimage.png?alt=media\&token=d5960bed-6a40-4b04-8773-751f92b0f4bd)

5\. Select **Date picker** from the dropdown menu

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2Fs1ZeJYT32SIbQzEd8oS4%2Fimage.png?alt=media\&token=bc4d7512-080b-4340-93b6-123719da8ed4)

6\. Add a **label** to display in the form

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FfLAsUg2KscHOqH7bI54w%2Fimage.png?alt=media\&token=3df08969-beb5-45e3-94c7-b1519dbdcfc2)

7\. Add a **field** name

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FKoUp3JskqKlfT9irmy5t%2Fimage.png?alt=media\&token=f0160a2d-e633-4557-938c-d671b7a67734)

{% hint style="danger" %}
If database is selected as data connection, then field name **must map** to destination table column name.
{% endhint %}

{% hint style="warning" %}
Field name cannot contain spaces.
{% endhint %}

8\. Click on **Done**

**Date picker** input column can now be updated and saved.

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FNCb3Jg2Ks1Mli2VHsrVD%2Fimage.png?alt=media\&token=d9d9a379-1592-4b6e-b45c-dc5e5c37c44e)

### Setting a custom date format

If you wish to change the format used to display dates on your table, please follow these steps:

1\. Edit your sheet\
2\. Click on the **Qommentary Form** extension\
3\. Expand the **Input fields** section and **Date picker** option\
4\. Click on **Date Format** text field and update the format. An expression may be used if desired.

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2Fe7ZPpU40GJqTOY27COJ7%2Fimage.png?alt=media\&token=e3daa285-9656-4bc8-9dd6-9417e26fe489)

Example of date formats: