Using FMP 12 created a Case Logical Function to determine County Sales Tax based on when guest arrived/arrives and departed/departs. Tried two versions:

Case(ARR < Date ( 10 ; 1 ; 2008 ) ; Actual Rm Tot * .025 ; ARR ? Date ( 10 ; 1 ; 2008 ) and DPT < Date ( 10 ; 1 ; 2009 ) ; Actual Rm Tot * .0225 ; (ARR ? Date ( 10 ; 1 ; 2009 ) and DPT < Date ( 10 ; 1 ; 2016) ; Actual Rm Tot * .02; ARR ? Date ( 10 ; 1 ; 2016 ); Actual Rm Tot * .0225 )


Case(ARR < Date ( 10 ; 1 ; 2008 ) ; Actual Rm Tot * .025 ; (ARR ? Date ( 10 ; 1 ; 2008 ) and DPT ? Date ( 9 ; 30 ; 2009 )) ; Actual Rm Tot * .0225 ; (ARR ? Date ( 10 ; 1 ; 2009 ) and DPT ? Date ( 9 ; 30 ; 2016)) ; Actual Rm Tot * .02; ARR ? Date ( 10 ; 1 ; 2016 ); Actual Rm Tot * .0225 )

works well with exception returns no results for either:

- an arrival in Sep 2009 with a departure in Oct 2009

and

- an arrival in Sep 2016 with a departure in Oct 2016

What am I missing?

George Ware
Innkeeper

The Chalet Inn , Inc Visit us Online at: http://www.ChaletInn.com
285 Lone Oak Drive and http://www.ChaletSuites.com
Whittier, NC 28789 and http://www.ChaletStube.com
mailto: ParadiseFound@ChaletInn.com
(828) 586-0251 / (800) 789-8024
GPS: 35 23'23.21"N 83 18'55.62"W

#############################################################
This message is sent to you because you are subscribed to
the mailing list FMPro
FMPro@lists.lassosoft.com
To unsubscribe, E-mail to: <FMPro-unsubscribe@lists.lassosoft.com>
Send administrative queries to <FMPro-request@lists.lassosoft.com>