R
Rose
I am trying to figure out how to calculate between two days if the second
date is blank. Currently, I run a query that subtracks CheckOutDate by
CheckInDate. and gives me the number of nights. Is there a way to say if
CheckOutDate Null calculate by Now() or by Date Entered []?
Nights: [CheckOutDate]-[CheckInDate]
date is blank. Currently, I run a query that subtracks CheckOutDate by
CheckInDate. and gives me the number of nights. Is there a way to say if
CheckOutDate Null calculate by Now() or by Date Entered []?
Nights: [CheckOutDate]-[CheckInDate]