Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.