topic Re: days between two dates in QlikView

days between two dates

Anonymous — Tue, 24 Mar 2015 12:42:37 GMT

hi all ,

i have dates below ,

i would like to find the no of days between these dates

01/15/2014 and 02/20/2014 (these dates are in MM/DD/YYYY format)

Thanks in Advance

Re: days between two dates

PrashantSangle — Tue, 24 Mar 2015 12:44:32 GMT

Hi,

Use Interval(first_date-secondDate,'D')

Regards

Re: days between two dates

Anonymous — Tue, 24 Mar 2015 12:54:59 GMT

Hi max ,

Thanks for ur reply , its not working

Thanks

Re: days between two dates

Gabriel — Tue, 24 Mar 2015 12:56:02 GMT

Hi,

Try

= Date('05/01/2014','MM/DD/YYYY') - Date('02/10/2014','MM/DD/YYYY')

= Date(DateField,'MM/DD/YYYY') - Date(DateField,'MM/DD/YYYY')

i.e End date - Start date

Re: days between two dates

maxgro — Tue, 24 Mar 2015 12:57:27 GMT

=Date#('02/20/2014', 'MM/DD/YYYY') - date#('01/15/2014', 'MM/DD/YYYY')

Re: days between two dates

Anonymous — Tue, 24 Mar 2015 13:04:50 GMT

What do you mean by "it's not working"? Have to be more specific.

It is working - see attached.

Re: days between two dates

PrashantSangle — Tue, 24 Mar 2015 13:05:01 GMT

Hi,

Try below two

Interval(Date(Date#(first_date,'MM/DD/YYYY'))-Date(Date#(secondDate,'MM/DD/YYYY')),'D')

Num(Date#(first_date,'MM/DD/YYYY'))-Num(Date#(secondDate,'MM/DD/YYYY'))

Regards

Re: days between two dates

Anonymous — Tue, 24 Mar 2015 13:10:48 GMT

See the link for same problem

http://community.qlik.com/message/733210#733210

Thanks

BKC

Re: days between two dates

Anonymous — Tue, 24 Mar 2015 13:21:50 GMT

2nd expression is working fine .A very thanks for your solution

fabs(Num(Date#(first_date,'MM/DD/YYYY'))-Num(Date#(secondDate,'MM/DD/YYYY')))

Thanks

Re: days between two dates

jonathandienst — Tue, 24 Mar 2015 13:23:42 GMT

Please all pay attention to the correct usage of Date() and Date#() and Interval() and Interval#()

Get the Dates Right