Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a table in which i have Order Logging Date and Request Delivery Date.
I want to subtract Request Delivery Date.- Order Logging Date and add a column no_of_days.
Thanks in advance!!
Try this.
Load *,Interval([Requested delivery date]-[Order Logging Date],'d') as No_of_Days;
LOAD Date(Date#([Order Logging Date], 'DD/MM/YYYY')) as [Order Logging Date],
Date(Date#([Requested delivery date], 'DD/MM/YYYY')) as [Requested delivery date]
FROM
File.xlsx
(ooxml, embedded labels, table is Sheet1);
Regards,
Kaushik Solanki
Hi,
Try like below,
load *, Interval(Date([Requested delivery date]-[Order Logging Date]),'d') as DateDiff;
LOAD * INLINE [
Order Logging Date, Requested delivery date
02/01/2017, 05/01/2017
02/01/2017, 05/01/2017
02/01/2017, 05/01/2017
07/01/2017, 10/01/2017
10/01/2017, 15/01/2017
16/01/2017, 20/01/2017
16/01/2017, 20/01/2017
16/01/2017, 20/01/2017
17/01/2017, 20/01/2017
17/01/2017, 20/01/2017
17/01/2017, 20/01/2017
17/01/2017, 20/01/2017
27/01/2017, 29/01/2017
27/01/2017, 29/01/2017
];
Try this.
Load *,Interval([Requested delivery date]-[Order Logging Date],'d') as No_of_Days;
LOAD Date(Date#([Order Logging Date], 'DD/MM/YYYY')) as [Order Logging Date],
Date(Date#([Requested delivery date], 'DD/MM/YYYY')) as [Requested delivery date]
FROM
File.xlsx
(ooxml, embedded labels, table is Sheet1);
Regards,
Kaushik Solanki
Hi Devarasu,
Thanks for your reply.But i can't get the desired result.Please find attached qvw file.
Hi,
in your expression use 'D' instead of 'S'
=Interval(Date([Requested delivery date])-Date([Order Logging Date]),'D')
Thanks for your reply kaushik.
I tried to get no of days in text object.
you want for each item? or difference between minimum and maximum date?
Regards,
Kaushik Solanki