Appointments & Scheduling · How-to guide

Filter appointment reports by date range

Apply a defined reporting period and compare like-for-like appointment performance.

Audience: Staff who manage appointmentsFeature: Report date rangeModule v1.3.6
Feature pathAppointments > Reports
Before you beginThis guide follows the supplied Britixo Appointments & Scheduling module version 1.3.6. The relevant access is Appointments: View Reports. A menu, button, provider, time slot or client action can remain hidden when the signed-in user lacks the required permission, the module setting is disabled, the related record is in an ineligible state, or availability validation rejects the request.

What this feature does

Apply a defined reporting period and compare like-for-like appointment performance. It uses Britixo's permission-aware appointment, availability, status and integration flow rather than an unconnected diary entry.

How the module flow works

The report controller accepts supported date boundaries and applies them to its appointment queries.

Period comparison uses separate current and previous datasets according to the selected range.

Date interpretation should be checked against the CRM and module timezone.

Step-by-step workflow

  1. Open Reports.
  2. Choose a preset or enter the start and end dates.
  3. Apply the filter.
  4. Confirm the period displayed above charts/tables.
  5. Export or compare only after checking the boundaries.

Important fields and decisions

Start dateInclusive lower reporting boundary according to query logic.
End dateUpper reporting boundary.
Comparison periodPrior period used by comparison data.
TimezoneContext affecting date classification.

What happens after completion

After this workflow completes, Britixo keeps the appointment and its supported relationships connected. Reopen the appointment and verify the saved status, date, timezone, customer or lead, service, provider, attendees, reminder state, calendar or meeting reference, invoice reference and history that apply to this feature. External email, SMS, Google, Microsoft or payment outcomes must be checked separately from the Britixo database save.

  • Open the saved appointment and confirm the final status and source.
  • Check the participant, provider, timing and timezone from the full detail page.
  • Review the relevant table filter, calendar, history, report or linked invoice instead of relying only on a success message.

Controls, checks and common mistakes

  • Do not compare a partial month with a complete month without explanation.
  • Check appointments near midnight.
  • Clear old filters before creating a new report.
  • Use the least destructive correction and retain the appointment history when the booking existed operationally.
  • Never bypass a permission, availability, approval, client-access or verification control by changing an unrelated route or setting.
Scheduling and data safetyAppointment changes can notify customers, reserve provider time, update remote calendars, create meeting links or invoices and alter reports. Confirm the exact record, timezone, status and recipients before saving.