Dates processor

• Convert to timestamp: Changes the type of date or time data to timestamp and sets a timestamp pattern.

• Convert to date: Changes the type of timestamp or time data to date and sets a date pattern.

• Convert to time: Changes the type of date or timestamp data to time and set a time pattern.

• Create timestamp from parts: Concatenate timestamp parts from different fields into a new one.

• Create date from parts: Concatenate date parts from different fields into a new one.

• Create time from parts: Concatenate time parts from different fields into a new one.

• Format date: Changes the date format to use in a date field.

• Calculate date difference: For a given time part unit, calculates the time between the dates in your field and the date of your choice.

• Add duration: Adds a specific amount of time to a date.

• Compare dates: Compares this field to another field or a constant

• Extract date parts: Creates fields with year, month, quarter, day, hour, minute, second, etc.

• Truncate date: Removes part of a date.

Select the field or fields on which you want to apply a function in the list.

Tip noteIf you want to apply the same function to multiple fields at once, click the Open dialog icon to open a tree view that allows you to select multiple fields.