/build/static/layout/Breadcrumb_cap_w.png

K1000 Service Desk: Advanced searching dates

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. =]

Comments

This post is locked

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ