Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.