Hello,
I need a column that gives me the Fiscal year and quarter i.e. “FY24/25 - Q1”, I am currently using the below formula but it returns “FY26-Q1”
“FY” & FORMAT_DATE(EDATE(FORMAT_DATE({Creation Log#Date}),9),“YY”)
& “-Q” & FORMAT_DATE(EDATE(FORMAT_DATE({Creation Log#Date}),9),“Q”)