Compare Dates in an If Statement (Calculating offset quarter)

[BruceB (Bruce Baldwin)]

@JCorrell

IF(FORMAT_DATE({Date},"Q")<>"","Q","") & FORMAT_DATE({Date},"Q")

Thanks. That’s a bit cleaner. It looks like it determines Q base on calendar year. What if you want to use your company’s fiscal year? Ours begins on Nov 1.