Hi,
I need to do a calculation with dates in a straight table. The objective is to calculate a new date combining the following conditions :
If Date <= November of Year N-1 THEN NewDate = September of Year N (is always on Sept).
e.g:
Year N = 2016
If Date = 10-10-2015 Then New Date = 01/09/2016
If Date = 30-10-2015 Then New Date = 01/09/2016
If Date > November of Year N-1 THEN NewDate = September of Year N+1 (is always on Sept).
e.g:
Year N = 2016
If Date = 02-11-2015 Then New Date = 01/09/2017
If Date = 30-12-2015 Then New Date = 01/09/2017
If Date = 02-01-2016 Then New Date = 01/09/2017
This is to be used in a straight table and the New Date is one of the columns of the table.
Could anyone help me to find out a solution for this?
Thanks
Regards
Paulo
