The Custom Report page allows reports to be run across a number of user-specified date periods, either fixed to a specific time period, or dynamically assigned relative to the current date & time.

The following fixed (i.e. conventional) date/time formats are available:

dd/mm/yyyy  - e.g. 26/11/2004.

dd/mm/yyyy hh:mm:ss  - e.g. 26/11/2004 12:30:00. For this (and all other dates with a time component) the seconds part is optional, but both hours and minutes must be included if either are required. In other words, 26/11/2004 12:30 would match the same data as 26/11/2004 12:30:00 .

dd month yyyy - e.g. 26 November 2004

dd month yyyy hh:mm:ss - e.g. 26 November 2004 12:30:00

Fixed date formats are often used for ad-hoc reports that do not need to be run repeatedly, but for reports that will be executed on a regular basis it is often more useful to specify relative dates and times; for instance, a report might be designed to find all the completions in the last 28 days. The following relative date/time formats are available:

today - specifies a relative date/time that matches data values for the today, using the current system time as a reference.

yesterday - specifies a relative date/time that matches data values for 24 hours prior to the current system time.

x <time period> ago - specifies a relative date/time that matches data values for (e.g.) 17 days ago, 3 months ago, etc. The available time periods are:

• days
• weeks
• months
• years

It is also generally possible to search on hours and minutes, although for case milestones this is inappropiate because the milestone dates do not provide a time. The 'Time Stored' field does, however, provide an accurate indication of the system time when the data was stored.

The Custom Report page will also recognise a number of common abbreviations for time periods.

start of this <time period> - specifies a relative date/time that matches data values for the start (e.g.) this week, this month, etc. Note that, for the purposes of specifying relative searches, the week starts on a Monday.

start of last <time period> - specifies a relative date/time that matches data values for the start (e.g.) last week, last year, etc.

start of x <time unit> ago - specifies a relative date/time that matches data values for (e.g.) the start of the week 3 weeks ago, first day of the month 6 months ago, etc.