Arcade Expression - Inspection Date in Current Quarter of Year

AshleyHayes2

Hello!  

I am trying to figure out how to write an Arcade expression that will determine if an inspection date occurred within the current quarter of the year (Jan-Mar, Apr-Jun, Jul-Sep, Oct-Dec).  My sense is that I need to convert the current date to quarter and the inspection date to quarter and see if they match, but I am not sure of the details for how to set that up.  Anyone done this before or have suggestions?

Thanks!

kenbuja

Here's one way to do it

 

var theDate = Date();
var testDate = Date(2022,7,4);

var theMonth = Month(theDate); //note Month is zero-based (Jan = 0)
var theYear = Year(theDate);
var quarter;
when (theMonth < 3, quarter = 1,
      theMonth < 6, quarter = 2,
      theMonth < 9, quarter = 3,
      quarter = 4);

var testMonth = Month(testDate);
var testYear = Year(testDate);
var testquarter;
when (testMonth < 3, testquarter = 1,
      testMonth < 6, testquarter = 2,
      testMonth < 9, testquarter = 3,
      testquarter = 4);
 
var output = "In current quarter";    
if (quarter != testquarter || theYear != testYear) output = "Not in current quarter";
return output;