Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
May I ask what function or syntax that be used in getting the aging of an invoice. Can someone give me an example?
Thank you
- Ahyel
May be
Age([Invoice Date], Today())
Hi Manish,
Thanks for this.. Just a clarification, do you mean the date TODAY? or will I use today as it is?
My apologies as I havent got any trainings for this yet,
Thank you so much
- AHyel
Today() is a qv function that returns current day date. However, if you want to calculate the age in no. of days, you should rather use expression like: =Today() - [Invoice Date] rather than age() which gives you completed years.
Hi Ahyel,
See attached....
If you want to find out number of Days, use as below..
=Interval(Today()-Date,'DD')
Okay, got it. But is it possible that if i make this syntax
Today()-Date#([Request Date],'DD.MM.YYYY') as Aging
the result in the X- axis will be numbers, right? How will i make it like for example, 1 = 1 day the 2 = 2 days.. Something like that..
Thank you so much
- Ahyel
Hi,
Try like this
Today()-Date#([Request Date],'DD.MM.YYYY') & ' Days' as Aging
Regards,
Jagan.
Try like:
Today()-Date#([Request Date],'DD.MM.YYYY') &
(If (Today()-Date#([Request Date],'DD.MM.YYYY')>1, 'Days', 'Day') as Aging