Custom-Reports: Difference between revisions
Jump to navigation
Jump to search
Markkinchin (talk | contribs) |
|||
| Line 508: | Line 508: | ||
*Template Variable = [MODIFYDATE:{%e %B, %Y}] equal [CURRENTDATE:-1day{%e %B, %Y}] | *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 | *Layout = Sortable Table | ||