Get quarter and year from date property

Type

Date

Option 1)

"Q" + formatDate(prop("Date"),"Q") + 
" " + 
formatDate(prop("Date"),"YYYY")

Result:

Option 2)

"Q" + formatDate(prop("Date"),"Q") + 
" " + 
formatDate(prop("Date"),"YY")

Result:

Option 3)

"Q" + formatDate(prop("Date"),"Q") + 
"/" + 
formatDate(prop("Date"),"YY")

Result:

Note: For formulas containing a date range (start and end dates), the quarter will be determined by the start date.