> 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/date-time-variable-options.md).

# Date Time Variable Options

Date Time Variables can enhance your query and file date templating and variable options. This allows easier scheduling and programmatic templating for common date variables.

{% hint style="warning" %}
File names must use the `{yyyy}-{MM}-{dd}` format in file date templates.
{% endhint %}

| Key      | Function                                                                                         |
| -------- | ------------------------------------------------------------------------------------------------ |
| ${rd}    | Replaces with -rd values in CMD. For example, 2023-01-20.                                        |
| ${rdEnd} | Replaces with -rdEnd values in CMD.                                                              |
| ${yyyy}  | Replaces with 4-digit year portion of -rd values in CMD. For example, 2023.                      |
| ${yy}    | Replaces with 2-digit year portion of -rd values in CMD. For example, 23.                        |
| ${M}     | Replaces with 1-digit month portion of -rd values in CMD.                                        |
| ${MM}    | Replaces with 2-digit month portion of -rd values in CMD.                                        |
| ${MMM}   | Replaces with 3 letter month name portion of -rd values in CMD For example, Jan, Jul, Dec.       |
| ${MMMM}  | Replaces with long month name portion of -rd values in CMD For example, January, July, December. |
| ${d}     | Replaces with 1 digit day portion of -rd values in CMD.                                          |
| ${dd}    | Replaces with 2 digit day portion of -rd values in CMD.                                          |
| ${HH}    | Replaces with 2 digit hour portion of -rd values in CMD.                                         |
| ${KK}    | Replaces with 1 digit hour portion of -rd values in CMD.                                         |
| ${mm}    | Replaces with 2 digit minute portion of -rd values in CMD.                                       |
| ${ss}    | Replaces with 2 digit second portion of -rd values in CMD.                                       |