Data export due by is confusing

  • 30 July 2019
  • 2 replies
  • 13 views

Hi,

So I'm trying to deal with data exports to use in PowerBi.
I have a due by date for a ticket in 7 days.
But in the export it says: 02:31.0

I'm not sure what that's in.
I figured out that 0.00 is overdue (would be nice for this to be done in date tho so I can calculate it myself)
But some tickets are 0.0 despite not being due yet. 
There's 
59:59.0 as well but not sure what that means.
Just need some assistance with this export and due by dates.

Regards,
Lochy.


This topic has been closed for comments

2 replies

Hi Lochy, 


I see that you have closed this forum on the ticket we had raised for you. 


Please feel free to reach out to us if you have any further questions, I'd be happy to help.


Happy supporting! 

please check if it not Epoch time, you will probably need to to convert it back to normal human readable time.