Search

Date Expressions

Last Updated: Mar 15, 2021

Articles

Functions Description Inputs Example
Extract Second Extracts the value of seconds from the
column value
No inputs Extract Second()
Extracts 01
from the column value
28-March-2021 18:30:01
Extract Minute Extracts the value of minutes from the
column value
No inputs Extract Minute()
Extracts 30 from the
column value
28-March-2021 18:30:01
Extract Hour Extracts the value of hour from the
column value
No inputs Extract Hour()
Extracts 18 from the
column value
28-March-2021 18:30:01
Extract Day Extracts the value of day from the
column value
No inputs Extract Day()
Extracts 28 from the
column value
28-March-2021 18:30:01
Extract Day Of Week Extracts the number of day of the week
from the column value
No inputs Extract Day Of Week()
Extracts 6 from the
column value
28-March-2021 18:30:01
Extract Week Extracts the number of week of the year from the
column value
No inputs Extract Week()
Extracts 13 from the
column value
28-March-2021 18:30:01
Extract Day Of Year Extracts the number of day of the year
from the column value
No inputs Extract Day Of Year()
Extracts 87 from the
column value
28-March-2021 18:30:01
Extract Month Extracts the number of month from the column value No inputs Extract Month()
Extracts 3 from the
column value
28-March-2021 18:30:01
Extract Quarter Extracts the number of quarter
from the column value
No inputs Extract Quarter()
Extracts 1 from the
column value
28-March-2021 18:30:01
Extract Year Extracts the value of year from the
column value
No inputs Extract Year()
Extracts 2021 from the
column value
28-March-2021 18:30:01
Extract Week Year Extracts the year and the number of
week of the year from the column value
No inputs Extract Week Year()
Extracts 2021-13 from the
column value
28-March-2021 18:30:01
Extract Quarter Year Extracts the year and the number of quarter from the column value No inputs Extract Quarter Year()
Extracts 2021-01 from the
column value
28-March-2021 18:30:01
Extract Month Year Extracts the year and the number of month from the column value No inputs Extract Month Year()
Extracts 2021-03 from the column value
28-March-2021 18:30:01
To String Convert the column value to a string length: Length of the string To String(5)
Converts June1981 to June1
Expression Add an Expression ExpressionString:
The expression to be added
Date Difference Extracts the difference between the
column value and today’s date in
terms of the intervals selected
Select $Today in the first drop-down

Select Interval: Select the interval
in terms of Years, Months, Weeks,
Days, Hours, Minutes or Seconds
Custom Date Difference Extracts the difference between the
column value and the specified date
in terms of the intervals selected
endDate: Specify the date to find the difference

Select Interval: Select the interval
in terms of Years, Months, Weeks,
Days, Hours, Minutes or Seconds
Date Add Adds the specified date to the column value Specify the Years, Months, Weeks,
Days, Hours, Minutes or Seconds
to add to the column value
Date Sub Subtracts the specified date from the
column value
Specify the Years, Months, Weeks,
Days, Hours, Minutes or Seconds to subtract from the column value
Extract Date Extracts the value of date from the
column value
No inputs Extract Second()
Extracts 28 from the column value
28-March-2021 18:30:01
Did you find what you were looking for?