AnsweredAssumed Answered

Question about period

Question asked by beroalde on Sep 17, 2018
Latest reply on Sep 17, 2018 by beroalde

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

amount= 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