Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date calculation issue

Hi all, writing a piece to analyse data from one of our feedback systems. Problem is that it displays the date in format DD-MM-YYYY HH-MM-SS-MS what I want to be able to do is do some calculations based on these dates, so I can work out the days before calls are breached, and calculate the numbers of days since the call was raised and group these into a column of calls that are 1 day old, 2 days old etc etc. However when I try to do what should be a simple date-date calculation I just end up with null values, even when I perform a left(datefield,10) first of all to reduce the date to DD-MM-YYYY. Any ideas for solutions would be most welcome, please find the offending item attached!

Cheers

Ben

1 Reply
Miguel_Angel_Baeyens

Use of date#() would help you that with something like

date#(DateField, 'DD-MM-YYYY HH-MM-SS-FF')
. Hope this helps.