Use the @date function to insert the current date and/or time into supported fields using customizable formatting codes. This is useful for creating time-stamped labels, naming columns, tracking changes, or generating dynamic values that reflect the exact time a workflow is executed.
To insert a date or time:
Start typing
@datein a supported fieldSelect a format code from the dropdown menu
Or manually enter a format, such as
@date%y-%m-%d
For example:
@date%y-%m-%d
Results in:
25-12-10
You can also combine multiple codes or include static text within the same field:
Report generated on @date%b %d, %y
Results in:
Report generated on Dec 10, 25
Where You Can Use @date
You can use @date in most fields across your workspace, including:
Column values
Column names
Static value transformations
Default field values
Where You Cannot Use @date
The @date function does not work in the following fields:
Workflow names
Dataset names
Pipeline names
Descriptions for workflows, datasets, or pipelines
If used in one of these unsupported fields, the value will be treated as plain text, not as a dynamic expression.
Available Format Codes
The table below lists all supported format codes that can be used with @date, along with output examples and plain-language explanations.
Code | Output Example | Natural Language Example |
| 25 | Add a new column with the current year in the format of yy |
| 12 | Add a new column with the current month in the format of mm (with leading zero) |
| 12 | Add a new column with the current month in the format of m (no leading zero) |
| dec | Add a new column with the abbreviated name of the current month |
| december | Add a new column with the full name of the current month |
| 08 | Add a new column with the current day of the month in the format of dd (with leading zero) |
| 8 | Add a new column with the current day of the month in the format of d (no leading zero) |
| wed | Add a new column with the abbreviated name of the current weekday |
| wednesday | Add a new column with the full name of the current weekday |
| 14 | Add a new column with the current hour in 24-hour format (hh with leading zero) |
| 14 | Add a new column with the current hour in 24-hour format (h without leading zero) |
| 02 | Add a new column with the current hour in 12-hour format (hh with leading zero) |
| 2 | Add a new column with the current hour in 12-hour format (h without leading zero) |
| pm | Add a new column with the current am/pm value |
| 07 | Add a new column with the current minute in the format of mm (with leading zero) |
| 7 | Add a new column with the current minute in the format of m (no leading zero) |
| 09 | Add a new column with the current second in the format of ss (with leading zero) |
| 9 | Add a new column with the current second in the format of s (no leading zero) |
| 123456 | Add a new column with the current microsecond in 6-digit format |
| +0000 | Add a new column with the current UTC offset |
| utc | Add a new column with the current time zone abbreviation |
| 344 | Add a new column with the current day of the year (1–366) |
| 3 | Add a new column with the current weekday as a number (1=Monday, 7=Sunday) |
| 3 | Add a new column with the current weekday as a number (0=Sunday, 6=Saturday) |
| 49 | Add a new column with the current week number (starting on Sunday) |
| 49 | Add a new column with the current week number (starting on Monday) |
Additional Examples
Here are some commonly used formats for quick reference:
Add the current date in yy-mm-dd format
@date%y-%m-%d
Add full timestamp in 24-hour format
@date%y-%m-%d %H:%M:%S
Add a label with full month and year
Monthly Report - @date%B %y
Add a compact string for filenames
backup_@date%y%m%d_%H%M
Add abbreviated month and year
@date%b %y
Tips for Using @date
Start typing
@dateand choose a format from the menu, or type your ownYou can combine multiple format codes and static text
Values are generated at runtime, so they always reflect the current date and time
Works well for dynamic tracking, labeling, and time-based filtering