Help

Quantity by 'day'

Topic Labels: Automations
197 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lake_Wilkinson
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1
MAX(1, DATETIME_DIFF({End Date}, {Start Date}, 'days'))