Date and Time

The Date and Time field type is used to handle date and time operations, formatting, and calculations. This field type provides several options for working with dates and times, including getting the current date and time, converting dates between different formats, adding time to a date, and subtracting time from a date.

Refer to the Day.js Date Format Documentation for standard date tokens.

Field Types

The Date and Time field type supports several operations for handling dates and times:

Field Type	Description
Current Date and Time	Get current date and time
Change Date Format	Convert date from one format to another
Increase Date	Add time to a date
Decrease Date	Subtract time from a date

Current Date and Time

Get current date and time.

Options

Options	Required
Date and Time Format	Yes

Date and Time Format

Specify the format for the current date and time output. Select from predefined formats or enter a custom format.

Change Date Format

Convert a date from one format to another format.

Options

Options	Required
Date Current Format	Yes
Date New Format	Yes

Date Current Format

Specify the current format of the date that you want to convert. This should match the format of the input date.

Date New Format

Specify the desired output format for the converted date.

Usage Notes

• If you have given element query in this field then scrape date from element text.
• If you haven't provided an element query then you must specify date in the field value or map it from your Excel (.xlsx) file.

Increase Date

Add a specified amount of time to a date.

Options

Options	Required
Date Format	Yes
Amount of Time Add	Yes
Date Output Format	Yes

Date Format

Specify the format of the input date that you want to increase.

Amount of Time Add

Specify how much time to add to the date:

• Value: Enter the numerical amount
• Unit: Select the time unit from the dropdown:
  • Day
  • Week
  • Month
  • Year
  • Hour
  • Minute
  • Second
  • Millisecond

Date Output Format

Specify the format for the output date after adding time.

Usage Notes

• If you have given element query in this field then scrape date from element text.
• If you haven't provided an element query then you must specify date in the field value or map it from your Excel (.xlsx) file.

Decrease Date

Subtract a specified amount of time from a date.

Options

Options	Required
Date Format	Yes
Amount of Time Subtracted	Yes
Date Output Format	Yes

Date Format

Specify the format of the input date that you want to decrease.

Amount of Time Subtracted

Specify how much time to subtract from the date:

• Value: Enter the numerical amount
• Unit: Select the time unit from the dropdown:
  • Day
  • Week
  • Month
  • Year
  • Hour
  • Minute
  • Second
  • Millisecond

Date Output Format

Specify the format for the output date after subtracting time.

Usage Notes

• If you have given element query in this field then scrape date from element text.
• If you haven't provided an element query then you must specify date in the field value or map it from your Excel (.xlsx) file.

Next Steps

• Field Types — Learn about different field types
• Field Response Actions — Configure response behaviors
• Excel Template — Prepare Excel (.xlsx) templates
• Site Settings — Configure site-wide automation settings