- Getting Started
- Administration Guide
- An Introduction to Wyn Enterprise
- Document Portal for End Users
- Data Governance and Modeling
- Working with Resources
- Working with Reports
- Working with Dashboards
- View and Manage Documents
Understanding Wyn Analytical Expressions
- Measures and Calculated Columns
- Use Cases
- Best Practices
- Section 508 Compliance
- Developer Guide
Time Intelligence Functions
The time intelligence function creates calculations that use built-in knowledge about calendars and dates. You can build meaningful comparisons across comparable periods for sales, inventory, etc. by using time and date ranges in combination with aggregations or calculations.
The DATEADD function returns a date, shifted either forward or backward in time by the specified number of intervals from the dates in the current context.
A column that contains dates.
An integer that specifies the number of intervals to add to or subtract from the dates.
The interval by which to shift the dates. The value for interval can be one of the following: year, quarter, month, or day.
A date or datetime value.
The above example will add the time in the SaleDate column, which is offset backward by 1 year.
The return value of this function is a scalar value.