Date Functions

Mike Jones
Mike Jones
  • Updated

Date functions are useful for formatting and evaluating date/time field values. You can combine date functions with other types of functions in your Field Pipeline to achieve data automation and data normalization use cases. 

 

Add to Date

This function adds to a date/time value. You can use this function to add seconds, minutes, hours, days, months or years to a date/time value. 

Configuration

mceclip0.png

1. Enter a label for the node. This will be helpful with identifying the node when viewing your Entity Pipeline.

2. Enter a Description that will explain what the function is configured to do.

3. Set the Amount to Add. This should be set as a number.

4. The Insert Token option allows you to set an Amount to Add value from a field.

5. Select the Unit to use with the Amount to Add. This is a pick list field with these options: Seconds, Minutes, Hours, Days, Months, Years.

 

Day of Month

This function evaluates an input date value returns the integer value for the day-of-month from 1 to 31.

Configuration

You can configure the Node Label and Description on this function. There are no other configurable fields. The function should be connected to a node that passes a date or date/time value.

Examples:

If the input date is 2020-03-22, the value returned by the function will be 22.

 

Day of Week

This function evaluates an input date and returns the integer value for the day-of-week.

1 - Monday
2- Tuesday
3 - Wednesday
4 - Thursday
5 - Friday
6 - Saturday
7 - Sunday

Configuration

You can configure the Node Label and Description on this function. There are no other configurable fields. The function should be connected to a node that passes a date or date/time value.

 

Day of Year

This function evaluates an input date and returns the integer value for the day-of-year. The value returned by this function will be an integer from 1 to 366 (366 for the last day in a leap year).

Configuration

You can configure the Node Label and Description on this function. There are no other configurable fields. The function should be connected to a node that passes a date or date/time value.


Date Format

Formats the given date into a date-time string using the date time pattern supplied.

Configuration

mceclip1.png

1. Enter a label for the node. This will be helpful with identifying the node when viewing your Entity Pipeline.

2. Enter a Description that will explain what the function is configured to do.

3. The Format Pattern is used to format the date/time value.

4. The Insert Token option allows you to set a Format Pattern from a field value.

Example:

The Format Pattern, yyyy-MM-dd'T'HH:mm:ssZ, will format a Date/Time value like this:
2019-07-07T00:00:00Z

 

Is After Now

This function compares the input date/time value to the current time. The function will return Trueif the input value is after now, otherwise the function will return False.

Configuration

You can configure the Node Label and Description on this function. There are no other configurable fields. The function should be connected to a node that passes a date or date/time value.

 

Is Before Now

This function compares the input date/time value to the current time. The function will return True if the input value is before now, otherwise the function will return False.

Configuration

You can configure the Node Label and Description on this function. There are no other configurable fields. The function should be connected to a node that passes a date or date/time value.

 

Now

This function returns the current date time in this format, 2021-01-05T01:19:06.158148Z[Etc/UTC]

Configuration

You can configure the Node Label and Description on this function. There are no other configurable fields. The function does not utilize the input value it will output the current date/time.

 

Subtract from Date

This function subtracts from a date/time value. You can use this function to subtract seconds, minutes, hours, days, months or years from a date/time value. 

Configuration

mceclip3.png

1. Enter a label for the node. This will be helpful with identifying the node when viewing your Entity Pipeline.

2. Enter a Description that will explain what the function is configured to do.

3. Set the Amount to Subtract. This should be set as a number.

4. The Insert Token option allows you to set an Amount to Subtract value from a field.

5. Select the Unit to use with the Amount to Subtract. This is a pick list field with these options: Seconds, Minutes, Hours, Days, Months, Years.

Date Difference Function

In field and entity pipelines, we compare information stored in Syncari with the information received from another system. Frequently, one of the actions is to compare two dates with one another to find the elapsed time between them.

The Date Difference function helps you keep track of different date fields, including support for Date Time fields. Select the fields you’d like to compare and the date difference unit, and calculate spans like the time from create date to converted date for a lead.

If you want to compare a date field to a relative time, you can do that with Relative Time Phrases. For example, to compare against today's current date/time, you can write:

before 0 seconds 

Here are the supported relative time phrases:

  • Before
  • After
  • Last
  • Next
Share this

Was this article helpful?

1 out of 3 found this helpful