Using IIF to create time intervals

  • Thread starter Thread starter Jeff S.
  • Start date Start date
J

Jeff S.

I'm trying to build an expression that groups individual accounts into
quarters based on service date (i.e., any service date where MM is October
through December = Q1, MM is January through March = Q2, etc.) How would I
go about structuring this expression?
 
Jeff said:
I'm trying to build an expression that groups individual accounts into
quarters based on service date (i.e., any service date where MM is October
through December = Q1, MM is January through March = Q2, etc.) How would I
go about structuring this expression?


Format(DateAdd("m", 3, [service date]), "\QQ")
 
Sounds like Fiscal Quarters. If so, then try this --
Expr1: "FY " & Format(DateAdd("m",3,[YourDate]),"yyyy") & " QTR " &
Format(DateAdd("m",3,[YourDate]),"q")
 
Back
Top