Hi guys,

I just wanted to share a little issue I worked through with Kace support in the hope that it can save someone else the same frustrations.

I was trying to use a 'matches REGEX' when search for dates on tickets and not having any success with my query.

Your experience might vary to mine depending on your language/date settings but for our install of Kace the dates are being displayed as 'dd/mm/yyyy hh:mm:ss'

However if I try and search for dates using this format, I wasn't getting any results. 

With the help of Kace support we fired up a copy of MYSQL Workbench and connected to the K1000 database and we were able to see the dates are in fact being stored in the following format. 'yyyy-mm-dd hh:mm:ss'

So in conclusion, if you want to use regex or search dates make sure you format your dates as 'yyyy-mm-dd'

I hope someone else finds this useful. =]