Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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.