If you need to convert a date value into a Year, Month, Week or Quarter value, XLReport will automatically insert the required expression for you.
Note! This functionality only applies for Data Connections to MS SQL Server, MS Access, MySQL and Oracle databases.
Add a new expression
- Select the table / view and field which holds the date value and click the Expression – Date Function button.
- Select a Date Function and click Ok .