2,903
edits
Changes
Jump to navigation
Jump to search
*Template Variable = [MODIFYDATE:{%e %B, %Y}] equal [CURRENTDATE:-1day{%e %B, %Y}]
*Layout = Sortable Table
Drag the columns with the information you want to see from "Available Columns" to "Show Columns".
=== Report of bookings cancelled between 2 dates===
For this report we are looking for all bookings with the Cancelled date between 1st-31st October 2021. Ensure the date format entered into the Template variable is YYYY-MM-DD
Create a custom report:
*Check In From = Any Date
*Check In To = Any Date
*Check Out From = Any Date
*Check Out To = Any Date
*Booking Date From = Any Date
*Booking Date To = Any Date
*Status = Cancelled
*Template Variable = [IFBETWEEN:[CANCELLEDTIME:{%Y-%m-%d}]:2021-10-01:2021-10-31:yes||]
*select 'equal' from the drop down list
*enter yes in the next box
*Layout = Sortable Table
