How to get a date difference from today

[#1]

Hi

I have a problem creating a field the shows me the difference in days between a field and the current date. Can someone please help me with this?

I have Now()-Createdate

but is does not work.

Simon

[swuehl]

Simon,

you probably need to interpret your Createdate as date, so QV assings a numeric value representation to the value, thus allowing Now() - Createdate to return the number of days.

Please check

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work

http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/07/automatic-number-interpretation

[#3]

Try this.

Today()-Date(Createdate)

Now()- is returns date with full timestamp MM-DD-YYYY hh:mm:ss ffff

today() - is returns MM-DD-YYYY

Regards,

Kabilan K.