DateTimeYear added to text

[RoliveIndeed]

I know there's a simple solution to this, but after searching for more than 10 mins I decided to just ask.

I'm trying to create FY and Qtr columns based on a date. 

For FY - I'm trying to say if the date is April 1st or greater, then "FY " + DateTimeYear([Date]), else "FY " + (DateTimeYear([Date]) -1)

For Qtr - I want to basically say if DateTimeYear([date]) < 4 Then "FY " + (DateTimeYear([Date]) -1) + " - Q4" and so on...

I'm gonna kick myself once someone gives me the answer, so thank you all in advance! 

[AncientPandaman · Accepted solution]

if DateTimeMonth([date]) >= 4 then
  "FY-"+tostring(DateTimeYear([date]))
else
  "FY-"+tostring(DateTimeYear([date])-1)
endif

[FY]+
"-Q"+tostring(CEIL(DateTimeMonth([date])/4))