Date transformation functions

Change Date

Change Date transformation function changes part of date

Change Date Dynamic

Change Date Dynamic transformation function changes part of date

Current Date

Date Format transformation function returns current date in ‘yyyy-mm-dd hh:nn:ss.fff' format

Date Diff

Date Diff transformation function returns difference of two dates

Date Format

Date Format transformation function returns Date in yyyy-mm-dd hh:nn:ss.fff format

Date part

Date part transformation function returns part of a date value

Date to Epoch

Date to Epoch transformation function converts Date to Epoch(Unix) Format

Epoch to Date

Epoch to Date transformation function converts Epoch (Unix Date) to Date

If 1st Quarter, If 2nd Quarter, Is 3rd Quarter, Is 4th Quarter, Is Current Quarter, Is Last Quarter, Is Next Quarter

If 1st Quarter, If 2nd Quarter, Is 3rd Quarter, Is 4th Quarter, Is Current Quarter, Is Last Quarter, Is Next Quarter Transformation Function

If Current Week, If Last Week, If Next Week

Checks if the data is a Date value which belongs to specific week

If Date

If Date transformation function checks if the data is a Date

If Date Between

If Date Between transformation function checks if the data is a Date between two values

If Date Less Than

If Date Between transformation function checks if the data is a Date less than value

If Date More Than

If Date Between transformation function checks if the data is a Date more than value

If January, If February, If March, If April, If May, If June, If July, If August, Is September, If October, If November, If December, If Current Month, If Last Month, If Next Month

If January, If February, If March, If April, If May, If June, If July, If August, Is September, If October, If November, If December, If Current Month, If Last Month, If Next Month Transformation Function