How to compare two dates in qlik sense

[rajendra1918]

Hi Friends,

I have two dates which is having current_date and old dates.

I want to to get from that how many days with hh:mm:ss

               Current date                    expire date

01.04.2010

31.10.2017

from the above dates i want to do subtract from expire date with start date.

Please help me. if there is any function available in qliksense.

Required:

dd hh:mm:ss

Regards,

Rajendra

[swuehl]

Not quite sure if I understood your setting, but if your dates are correctly interpreted as dates

(have a look at

Get the Dates Right

Why don’t my dates work?

)

then you can just subtract the date values to get the time interval between the two dates or timestamps.

You can use Interval() function to format the result.

For example

=Interval( Now() - Makedate(2017), 'dd hh:mm:ss')

[rajendra1918]

Hi Stefan- Thanks for reply,

i have used "date((date(Field1,'MM/DD/YYY')-date(Field2,'MM/DD/YYYY')),'DD')"  expression

now able to get what i required.

Thanks for your inputs.

Regards,

Rajendra

[swuehl]

i would strongly suggest to use Interval() function to format a time interval, I think something like Date( ..., 'DD') will not give you the correct number of days.

Just compare

=Date(1,'DD')

vs

=Interval(1,'dd')

[rajendra1918]

I will check with that and update you.

Thank you.

Regards,

Rajendra