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
as date#(Today(),'DD.MM.YYYY') will give you incorrect format so
try this
Date(Today(),'DD.MM.YYYY') -Date([Request Date],'DD.MM.YYYY') as Ageing
hope this helps
Hi,
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!!
Regards,
Ahyel
[PR Approve Date]- [PO Creation date] as fieldname
or
Interval(PR Aprove date],[Po creation date],'DD') as Field
use expressions provided directly in Expression
hope this make sense
Hi Jagan,
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!!
Regards,
Ahyel
Hi,
Try like this
LOAD
*,
Interval([PR Approved date] - [PO creation date], 'MM/DD/YYYY hh:mm:ss') AS Duration
FROM DataSource;
Regards,
Jagan.