> For the complete documentation index, see [llms.txt](https://knowledgebase.qommentary.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://knowledgebase.qommentary.com/qommentary-writeback/custom-data/adding-input-columns/date-picker.md).

# 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 Writeback** extension\
3\. Expand **Input Column** section\
4\. Click on **Add column**

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZCvqSqKXuXT2WpbY2f%2F-MZCx6ezSPuMpGDkleyH%2Fimage.png?alt=media&amp;token=c8a0c47a-fd65-447f-9bcf-fb1394cce274" alt=""></div>

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

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZDmpybG2AdAw1cYFFA%2F-MZG8-FkfyPUsT-nSct7%2Fimage.png?alt=media&amp;token=933fb329-23b1-4e2e-9d56-f1f87401e74e" alt=""></div>

6\. Add a **label** to be displayed as a column header

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZDmpybG2AdAw1cYFFA%2F-MZG8S__rppFGlBZG4Pt%2Fimage.png?alt=media&amp;token=261b94f4-778d-48f2-946c-a9dc8e8c0c47" alt=""></div>

7\. Add a **field** name

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZDmpybG2AdAw1cYFFA%2F-MZG8cN-TS_Nblx1n1GN%2Fimage.png?alt=media&amp;token=cad6fccc-f25a-4ba0-a3d8-295f2fffd684" alt=""></div>

{% 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://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZB4gxRzZ3nQKvAuoUR%2F-MZB5EyCzziRjFnMJX91%2Fimage.png?alt=media\&token=f93b8971-db25-4a2d-9a74-118f265b417d)

### 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 Writeback** extension\
3\. Expand the **Input Columns** section and **Date picker** column\
4\. Click on **Date Format** text field and update the format. An expression may be used if desired.

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZB4gxRzZ3nQKvAuoUR%2F-MZB6DpfKbUnjJ4gw3kD%2Fimage.png?alt=media&amp;token=a4603958-5759-4cff-a661-9ff20f19f741" alt=""></div>

Example of date formats:
