Ageing Debt using a Variable

[#1]

Hi All

I have created a variable (vDate) in which I can enter a specific date, i.e. the last date of the current month, in an effort to forecast my debt ageing as at that date into a number of categories.

I have then entered the below into the script however everything is being returned as being in the category "Greater than 120 Days", where am I going wrong?

thanks in advance

Iain

     IF(('vDate' - [CLE.Document Date])<=30,'0 - 30 Days',

     IF(('vDate' - [CLE.Document Date])<=60,'31 - 60 Days',

     IF(('vDate' - [CLE.Document Date])<=90,'61 - 90 Days',

     IF(('vDate' - [CLE.Document Date])<=120,'91 - 120 Days','Greater Than 120 Days')))) as [CLE.InvoiceAged Band Variable],

[Gysbert_Wassenaar · Accepted solution]

You're using a literal string: 'vDate' . Try vDate without the quotes or $(vDate). Make sure vDate contains a real date and not a string or you won't get a number of days back when you subtract CLE.Document Date from it.