days between two dates

[Anonymous]

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

[PrashantSangle]

Hi,

Use Interval(first_date-secondDate,'D')

Regards

[Anonymous]

Hi max ,

Thanks for ur reply , its not working

Thanks

[Gabriel]

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

[maxgro]

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

[Anonymous]

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

It is working - see attached.

[PrashantSangle · Accepted solution]

Hi,

Try below two

1)

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

2)

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

Regards

[Anonymous]

See the link for same problem

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

Thanks

BKC

[Anonymous]

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

[jonathandienst]

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

Get the Dates Right