How to get aging per day?

[#1]

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

[SunilChauhan]

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

[#3]

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

[SunilChauhan]

[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

[#5]

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

[jagan]

Hi,

Try like this

LOAD

*,

Interval([PR Approved date] - [PO creation date], 'MM/DD/YYYY hh:mm:ss') AS Duration

FROM DataSource;

Regards,

Jagan.