How to subtract Date

[Anonymous]

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!!

[devarasu07]

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

];

[kaushiknsolanki · Accepted solution]

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

[Anonymous]

Hi Devarasu,

Thanks for your reply.But i can't get the desired result.Please find attached qvw file.

[devarasu07]

Hi,

in your expression use 'D' instead of 'S'

=Interval(Date([Requested delivery date])-Date([Order Logging Date]),'D')

[Anonymous]

Thanks for your reply kaushik.

I tried to get no of days in text object.

[kaushiknsolanki]

you want for each item? or difference between minimum and maximum date?

Regards,

Kaushik Solanki