setting up an invoicing system for an air B&B, individual rooms are rented for varying days at my house. I want to be able to click the + on my calendar view and add a single day to be billed for. I have a ‘line item’ system set up that works great other than this issue. my problem is that unless i make the event TWO days my quantity field with the formula: DATETIME_DIFF({End Date}, {Start Date}, ‘days’) displays as 0, therefore charging nothing. how can i make one day = 1?
Quantity by 'day'
+27MAX(1, DATETIME_DIFF({End Date}, {Start Date}, 'days'))
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.