add_days | Adds the specified number of days to a date | add_days (01/30/2015, 5) = 02/04/2015 |
add_minutes | Adds minutes to a date, datetime, or time | add_minutes (01/30/2015 00:10:20, 5) = 01/30/2015 00:15:20 |
add_months | Adds months to a date | add_months (01/30/2015, 5) = 06/30/2015 |
add_seconds | Adds seconds to a date/datetime/time | add_seconds (01/30/2015 00:00:00, 5) = 01/30/2015 00:00:05 |
add_weeks | Adds weeks to a date | add_weeks (01/30/2015, 2) = 02/13/2015 |
add_years | Adds years to a date | add_years (01/30/2015, 5) = 01/30/2020 |
date | Returns the date portion of a date | date (home visit) |
day | Returns the day of the month (1-31) | day (01/15/2014) = 15 |
day_number_of_quarter | Day number within a quarter. Optional 'fiscal' / 'calendar' (default 'calendar') | day_number_of_quarter (01/30/2015) = 30 |
day_number_of_week | Day number within a week; Monday = 1, Sunday = 7 | day_number_of_week(01/15/2014) = 3 |
day_number_of_year | Day number within a year (1-366). Optional 'fiscal' / 'calendar' | day_number_of_year (01/30/2015) = 30 |
day_of_week | Day of the week for a date | day_of_week (01/30/2015) = Friday |
diff_days | Difference between two dates, in days (rounded down) | diff_days (01/15/2014, 01/17/2014) = -2 |
diff_time | Difference between two dates, in seconds | diff_time (01/30/2014, 01/31/2014) = -86,400 |
hour_of_day | Hour of the day for a date | |
is_weekend | true if the date is a Saturday or Sunday | is_weekend (01/31/2015) = true |
month | Month from the date | month (01/15/2014) = January |
month_number | Month number (1-12). Optional 'fiscal' / 'calendar' | month_number (09/20/2014) = 9 |
month_number_of_quarter | Month number (1-3) within a quarter. Optional 'fiscal' / 'calendar' | month_number_of_quarter (02/20/2018) = 2 |
now | Current date and time, in your locale’s format | now () |
quarter_number | Quarter number (1-4). Optional 'fiscal' / 'calendar' | quarter_number (04/14/2014) = 2 |
start_of_month | First day of the month, as MMM yyyy | start_of_month (01/31/2015) = Jan FY 2015 |
start_of_quarter | First day of the quarter. Optional 'fiscal' / 'calendar' | start_of_quarter (04/30/2014) = Apr 2014 |
start_of_week | First day of the week | start_of_week (01/31/2020) = 01/27/2020 |
start_of_year | First day of the year. Optional 'fiscal' / 'calendar' | start_of_year (04/30/2014) returns Jan 2014 |
time | Time portion of a date | time (1/31/2002 10:32) = 10:32 |
today | Current date, in your locale’s format | today () |
week_number_of_month | Week number within a month | week_number_of_month(03/23/2017) = 3 |
week_number_of_quarter | Week number within a quarter. Optional 'fiscal' / 'calendar' | week_number_of_quarter (01/31/2020) = 5 |
week_number_of_year | Week number within a year. Optional 'fiscal' / 'calendar' | week_number_of_year (01/17/2014) = 3 |
year | Year from a date. Optional 'fiscal' / 'calendar' | year (01/15/2014) = 2014 |
