# 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:


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://knowledgebase.qommentary.com/qommentary-writeback/custom-data/adding-input-columns/date-picker.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
