Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use of date#() would help you that with something like
. Hope this helps.date#(DateField, 'DD-MM-YYYY HH-MM-SS-FF')