Hello,
I've got a select query in which I've created a formula to work out if a 'deferral date' should be provided for an order line.
A: IIf(DateDiff("m",[Instalment Posting Date],[Start date]) Is Null And DateDiff("m",Date(),[Start date])>=1,[Start Date],"")
B: IIf(DateDiff("m",[Instalment...