how to calculate count of days between two days

[#1]

Hello All,

I have two days,m i need to calculate count of days between those dates in qliksense

for example,

if i have today(), orderdate,

i have order date is 01-04-2015, today() is 15-04-2015,

the difference between two dates is 15days, how to get this count?

Thanks in advance

Regards,

Sreeharsha V

[#2]

=today() - order_date should work.

Another example.put this expression in the textbox and check

=Today() - makedate(2015,1,1) // Returns 103

[#3]

Please try:

=ceil(OrderDate - Today())

[goncalo_ricardo_pereira · Accepted solution]

Hello,

You can try something like this:

fabs(Interval(OrderDate - Today(),'d'))

The function "Interval", gives you the difference between the two dates in days. The function "Fabs", make sure that the result is always > 0.

Best Regards,

Gonçalo Pereira