Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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],
Hi,
Do you want to use that date in reloading the script or graphics? If in graphics you could use an input box.
Rebeca