There are several 'Date Formats' that are used across all of the reports. Some of them have different meanings depending on the report type. The following chart lists the 'Date Format' types and the report categories in which they appear. If a report category is not specified, then the 'Date Format' description is the same across all of the reports.
If you can select multiple date ranges in a report's criteria, the output will include an overlap of those dates.
Date Type |
Report Category/Description |
Account Created Date |
This is date that the account was created. |
Account Update Date |
This is the date that the account was updated. |
Allocation Date |
•Accounting/Sales Reports: This is the date that the payment became allocated. •Donation Reports: If selected, the report will only display donations that have allocation activity during the date range. |
Balance Due Date |
This is the date that the balance is due. |
Contract Start Date |
This is the date that the contract started. |
Expiry Date |
This is the date that the gift certificate expires. |
Order Date |
This is the date that the order was created. |
Order Paid Date |
This is the date that order was paid. |
Payment Date |
This is the date that the payment was added or modified. |
Event Date |
This is the date of the event. This option only appears in the Sales Audit report. It allows you to define whether to filter the report for past events (Past Sales), future events (Advanced Sales) and a range of dates (Event Range). In all other instances the events dates act as a range. |
Pledge Date |
This is typically the date that the pledge was physically received. It is a user inputted value. |
Pricing Date |
This is the date that the pricing was effective. Filtering a report by price date or date range will return the pricing that was effective on or during that date range. |
Printed Date |
This is the date that the ticket was printed (or cancelled). |
Release Date |
This is the date the admissions were released/deleted from the order. |
Request Date |
This is the date that bundle and/or event request was added to the order. |
Sales Date |
•Accounting Reports: This is the date that the item on the order was sold, modified or deleted. •Gift Certificate and Gift Card Transactions Report: This is the date that the gift certificate was sold, modified, deleted and/or redeemed. •Sales Reports: This is the date that the item on the order was sold, modified or deleted. |
Scanning Date |
This is the date that the ticket was scanned |
Transaction Date |
•Accounting Reports: This is the date that the transaction took place. •AudienceView Reports: This is the date that the XX was sold. •Charges Report: This is the date that the charge was issued/sold. •Donation Reports: This is the date that a gift was added to an order. |
Unallocated Date |
This is the date that the unallocated payment (an overpayment) was made. |
