cancel
Showing results for 
Search instead for 
Did you mean: 

Calculating Age of two different posting dates

Former Member
0 Kudos

Hi All,

I have to create a query in which I need to display the number of days between 'Purchase Order Posting Date' and 'Invoice Posting date'.

Let me explain this better with an example:-

I have 'Purchase Order Posting Date'(PO Date) and 'Invoice Posting Date'(Inv Date), now say I have PO Date as 12/21/2005 and Inv Date as 1/18/2006. I need to show also a third column which shows the number of days between these two posting dates.

<i>PO Date</i>----<i>Inv Date</i>-<i>PO/INV</i> (calendar days)

<i>12/21/2005</i>-<i>1/18/2006</i>--<i>28</i>

I hope the question is now clear.

Any help in this regard will be appreciated.

Thanks & Rgds,

M

Accepted Solutions (1)

Accepted Solutions (1)

former_member183777
Active Contributor
0 Kudos

Create a Formula Variable of type Replacement Value for each of the dates. Then create another formula to get the difference of value from these two replacement variables. You may have to use the Date function on the variables to get a date difference.

Answers (0)