Debt Ageing on a Specific Date

[#1]

Hi All

I currently have the below in my script that ages my debt based on todays date.  I would however like to be able to age it by a specific date, for example instead of having "Today" in the script have a variable that would allow me to enter any date.

Thanks in anticipation.

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

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

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

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

[#2]

Hi,

Do you want to use that date in reloading the script or graphics? If in graphics you could use an input box.

Rebeca