Hi, I am using this statement.
Format(IIf([Last Payment Made]<DateAdd("d",3,[DueDate])),0,[AmountDue]*0.1))),"Currency")
Last Payment Made is a date field Dlookup, short date format.
Due Date is in the table, short date format.
The issue:
Say my DueDate is 1/1/2016
If my Last Payment Made Date is on or before 1/4/2016 it shows 0 as it should
If my Last Payment Made Date is after 1/4/2016 up to 1/9/2016 it triggers [AmountDue]*0.1 as it should
Now here it is -- If my Payment Made Date is anytime after 1/9/2016 it will not trigger [AmountDue]*0.1... anything with 1/10/2016 or any 1/XX/2016. It appears that double digits in the "Day" kill the [AmountDue]*0.1 if it is > greater than the due date +3....
Any ideas why? I have spent countless hours on this and cannot find a reason...
You will forever be my hero if this can be solved...
Fen How
Format(IIf([Last Payment Made]<DateAdd("d",3,[DueDate])),0,[AmountDue]*0.1))),"Currency")
Last Payment Made is a date field Dlookup, short date format.
Due Date is in the table, short date format.
The issue:
Say my DueDate is 1/1/2016
If my Last Payment Made Date is on or before 1/4/2016 it shows 0 as it should
If my Last Payment Made Date is after 1/4/2016 up to 1/9/2016 it triggers [AmountDue]*0.1 as it should
Now here it is -- If my Payment Made Date is anytime after 1/9/2016 it will not trigger [AmountDue]*0.1... anything with 1/10/2016 or any 1/XX/2016. It appears that double digits in the "Day" kill the [AmountDue]*0.1 if it is > greater than the due date +3....
Any ideas why? I have spent countless hours on this and cannot find a reason...
You will forever be my hero if this can be solved...
Fen How