May I ask what function or syntax that be used in getting the aging of an invoice. Can someone give me an example?
Age([Invoice Date], Today())
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
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.
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..
Try like this
Today()-Date#([Request Date],'DD.MM.YYYY') & ' Days' as Aging
can you help me on this?
How can I get the duration of processing from two dates?
From PR Approved date to PO creation date including the weekend?
Thanks a lot!!
Interval([PR Approved date] - [PO creation date], 'MM/DD/YYYY hh:mm:ss') AS Duration
Today()-Date#([Request Date],'DD.MM.YYYY') &
(If (Today()-Date#([Request Date],'DD.MM.YYYY')>1, 'Days', 'Day') as Aging
as date#(Today(),'DD.MM.YYYY') will give you incorrect format so
Date(Today(),'DD.MM.YYYY') -Date([Request Date],'DD.MM.YYYY') as Ageing
hope this helps
Can you help me on this?
[PR Approve Date]- [PO Creation date] as fieldname
Interval(PR Aprove date],[Po creation date],'DD') as Field
use expressions provided directly in Expression
hope this make sense
If you want to find out number of Days, use as below..
Age function can be used.
This might be of help:
Re: Age Field
Retrieving data ...