Error Message with Switch Function. True or False Formula

[Bgordon10]

Hello, 

I am trying to determine if the date falls between two dates and also within the specific fiscal year. We are trying to sum totals with a cut-off date. The cut-off date is the same every year. I'm not sure if this formula is the most efficient so I am open to other suggestions. This field will be used as a filter (yes or no) but I am getting this message below. 

Function 'SWITCH' does not support comparing values of type True/False with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

SWITCH (
TRUE (),
IF(Summary[APPLICATION_DATE] >= DATE(2019,7,1) && Summary[APPLICATION_DATE] <= DATE(2020,03,31)
&& Summary[FY] = "2019-2020","Yes", "No"),
IF(Summary[APPLICATION_DATE] >= DATE(2020,7,1) && Summary[APPLICATION_DATE] <= DATE(2021,03,31)
&& Summary[FY] = "2020-2021","Yes","No"),
IF(Summary[APPLICATION_DATE] >= DATE(2021,7,1) && Summary[APPLICATION_DATE] <= DATE(2022,03,31)
&& Summary[FY] = "2021-2022","Yes","No"))

[Vijay_A_Verma · Accepted solution]

Use below formula

=SWITCH (
TRUE (),
(Summary[APPLICATION_DATE] >= DATE(2019,7,1) && Summary[APPLICATION_DATE] <= DATE(2020,03,31)
&& Summary[FY] = "2019-2020" || 
Summary[APPLICATION_DATE] >= DATE(2020,7,1) && Summary[APPLICATION_DATE] <= DATE(2021,03,31)
&& Summary[FY] = "2020-2021" ||
Summary[APPLICATION_DATE] >= DATE(2021,7,1) && Summary[APPLICATION_DATE] <= DATE(2022,03,31)
&& Summary[FY] = "2021-2022"),"Yes",
"No")

Another variation is to use IF not Switch

=IF(
(Summary[APPLICATION_DATE] >= DATE(2019,7,1) && Summary[APPLICATION_DATE] <= DATE(2020,03,31)
&& Summary[FY] = "2019-2020" || 
Summary[APPLICATION_DATE] >= DATE(2020,7,1) && Summary[APPLICATION_DATE] <= DATE(2021,03,31)
&& Summary[FY] = "2020-2021" ||
Summary[APPLICATION_DATE] >= DATE(2021,7,1) && Summary[APPLICATION_DATE] <= DATE(2022,03,31)
&& Summary[FY] = "2021-2022"),"Yes",
"No")