> 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="/files/-MZCx6ezSPuMpGDkleyH" alt=""></div>

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

<div align="left"><img src="/files/-MZG8-FkfyPUsT-nSct7" alt=""></div>

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

<div align="left"><img src="/files/-MZG8S__rppFGlBZG4Pt" alt=""></div>

7\. Add a **field** name

<div align="left"><img src="/files/-MZG8cN-TS_Nblx1n1GN" 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.

![](/files/-MZB5EyCzziRjFnMJX91)

### 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="/files/-MZB6DpfKbUnjJ4gw3kD" alt=""></div>

Example of date formats:
