Easy Insight Logo
Call 1-(720)-316-8174

Date Functions

businessdayofmonth returns the business day of month of the selected date.

businessdayofmonth()

returns the current business day of month.

businessdayofmonth([date field])

returns the business day of month of the date passed as a parameter.

businessdaysinmonth returns the number of business days in the month of the selected date.

businessdaysinmonth()

returns the number of business days in the current month.

businessdaysinmonth([date field])

returns the number of business days in the month of the selected date.

dayofweek returns the day of week of the selected date.

dayofweek()

returns the current day of week.

dayofweek([date field])

returns the day of week of the date passed as a parameter.

dayofyear returns the day of year of the selected date.

dayofyear()

returns the current day of year.

dayofyear([date field])

returns the day of year of the date passed as a parameter.

daysinmonth returns the number of days in the month of the selected date.

daysinmonth()

returns the number of days in the current month.

daysinmonth([date field])

returns the number of days in the month of the selected date.

fiscalyearstart returns the first month of the year as defined by your fiscal year (configured under Account Settings).

fiscalyearstart()

returns the first month of the fiscal year.

fiscalyearend returns the last month of the year as defined by your fiscal year (configured under Account Settings).

fiscalyearend()

returns the first month of the fiscal year.

month returns the month of the selected date.

month()

returns the current month.

month([date field])

returns the month of the date passed as a parameter.

months returns the specified interval of months, for example:

nowdate() - months(2)

would calculate the date two months prior to now.

nowdate returns the current date:

nowdate()

quarters returns the specified interval of quarters, for example:

nowdate() - quarters(2)

would calculate the date two quarters prior to now.

weekofyear returns the week of year of the selected date.

weekofyear()

returns the current week of year.

weekofyear([date field])

returns the day of week of year passed as a parameter.

weeks returns the specified interval of weeks, for example:

nowdate() - weeks(2)

would calculate the date two weeks prior to now.

year returns the year of the selected date.

year()

returns the current year.

year([date field])

returns the year of the date passed as a parameter.

years returns the specified interval of years, for example:

nowdate() - years(2)

would calculate the date two years prior to now.