> For the complete documentation index, see [llms.txt](https://docs.collibra.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.collibra.com/data-quality-self-hosted/core-concepts/findings/data-quality-monitors/job-tab/job-command-line-parameters/advanced/add-date-column.md).

# Add Date Column

The add date column (`-adddc`) function allows you to create a new date column in file-based datasets, providing date column when existing date information is missing or corrupted.

{% hint style="info" %}
You can use `-adddc` for file-based datasets. This function does not apply to datasets based on database tables.
{% endhint %}

When you use this function, it adds a column named **OWL\_RUN\_ID**, which contains the specific run date you enter during execution.

You can use the `-adddc` function when the dataset:

* Does not contain any date columns.
* Contains malformed or unusable date strings.

## Example

The following example shows a file-based dataset with the `-adddc` function and a run date (`-rd`) of 2025-07-01.

```
./owlcheck \
-ds "datataset_date_column" \
-rd "2025-07-01" \
-f "/Users/Downloads/csv2/2025010.csv" \
-adddc
```
