Dynamically Insert Dates and Times

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 @date in a supported field

• Select 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
%y	25	Add a new column with the current year in the format of yy
%m	12	Add a new column with the current month in the format of mm (with leading zero)
%-m	12	Add a new column with the current month in the format of m (no leading zero)
%b	dec	Add a new column with the abbreviated name of the current month
%B	december	Add a new column with the full name of the current month
%d	08	Add a new column with the current day of the month in the format of dd (with leading zero)
%-d	8	Add a new column with the current day of the month in the format of d (no leading zero)
%a	wed	Add a new column with the abbreviated name of the current weekday
%A	wednesday	Add a new column with the full name of the current weekday
%H	14	Add a new column with the current hour in 24-hour format (hh with leading zero)
%-H	14	Add a new column with the current hour in 24-hour format (h without leading zero)
%I	02	Add a new column with the current hour in 12-hour format (hh with leading zero)
%-I	2	Add a new column with the current hour in 12-hour format (h without leading zero)
%p	pm	Add a new column with the current am/pm value
%M	07	Add a new column with the current minute in the format of mm (with leading zero)
%-M	7	Add a new column with the current minute in the format of m (no leading zero)
%S	09	Add a new column with the current second in the format of ss (with leading zero)
%-S	9	Add a new column with the current second in the format of s (no leading zero)
%f	123456	Add a new column with the current microsecond in 6-digit format
%z	+0000	Add a new column with the current UTC offset
%Z	utc	Add a new column with the current time zone abbreviation
%j	344	Add a new column with the current day of the year (1–366)
%u	3	Add a new column with the current weekday as a number (1=Monday, 7=Sunday)
%w	3	Add a new column with the current weekday as a number (0=Sunday, 6=Saturday)
%U	49	Add a new column with the current week number (starting on Sunday)
%W	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 @date and choose a format from the menu, or type your own

• You 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 ​