Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to get a date difference from today

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

Tags (4)
2 Replies
Highlighted
MVP
MVP

Re: How to get a date difference from today

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

Highlighted
Not applicable

Re: How to get a date difference from today

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.