On calendar date pick, populate fields with fiscal year and fiscal qtr

[4Justme2]

Once my enduser picks a date from a calendar popup I would like to automatically populate two fields: a fiscal year and fiscal quarter.

The fiscal year runs from July one year to the end of June the next.

July - Sept = fiscal quarter 1

Oct - Dec = fiscal quarter 2

Jan - Mar = fiscal quarter 3

April - Jun = fiscal quarter 4

[comment]

Try:

FY =

Year ( SelectedDate ) - ( Month ( SelectedDate ) < 7 )

FQ =

Div ( Mod ( Month ( SelectedDate ) - 7 ; 12 ) ; 3 ) + 1

Result is Number for both.

[4Justme2]

Excellent! Many thanks... mp