I have to change a database of one of my clients and I have a problem.
I have 3 fields (Payment_date, period, amount)
Payment_Date= date field
period= text or number
The "Period" field must be in the 2018-2019 format if the payment date is after or equal to June 1st of the payment date.
So how to do by calculation (or by script) so that the result of "Period" is 2017-2018 if the Payment_Date is before June 1st
or "Period = 2016-2017 if the Payment_date is 2 years after the Payment_Date?
I ‘m running FmPro advanced 16 and the solution must be compatible with FM12
Thanks in advance