Discussion Board for collaboration related to QlikView App Development.
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.
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.
Now()- is returns date with full timestamp MM-DD-YYYY hh:mm:ss ffff
today() - is returns MM-DD-YYYY