All
Firstly credit to Belleke, for the help in solving this problem, however haven't tested until now date with leading zeros.
The problem I have is that, when I use 01/02/18 (1st of Feb) on Reg11 (Date Completed), on Reg13 (Due In) the calculation (reg11+Reg12 Frequency ) is not correct.
Seems that, dates from:
Days: 01/03/04/05/06/07/08/09/10/11/12 of Feb fails;
Days: 02/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28 of Feb- OK
Tested with Marsh and it's the same.
Could anyone help me please?
Thanks in advance.
Regards
R
Firstly credit to Belleke, for the help in solving this problem, however haven't tested until now date with leading zeros.
The problem I have is that, when I use 01/02/18 (1st of Feb) on Reg11 (Date Completed), on Reg13 (Due In) the calculation (reg11+Reg12 Frequency ) is not correct.
Seems that, dates from:
Days: 01/03/04/05/06/07/08/09/10/11/12 of Feb fails;
Days: 02/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28 of Feb- OK
Tested with Marsh and it's the same.
Could anyone help me please?
Thanks in advance.
Regards
R