/build/static/layout/Breadcrumb_cap_w.png
What date format do I need to use to create a custom filter in the Help Desk module e.g. tickets opened after 1/1/2010?
I'm a newbie to KBOX, so apologies if this is a silly question. [:)]

Alistair
0 Comments   [ + ] Show comments

Comments


Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

All Answers

0
You may try the format like this '1990-10-02' i mean 'yyyy-mm-dd' in the WHERE clause
Answered 02/11/2010 by: afzal
Fourth Degree Green Belt

0
The standard date format for the US in MySQL is YYYY-MM-DD.
Answered 02/12/2010 by: airwolf
Tenth Degree Black Belt

0
And keep in mind that most dates are stored in our database as timestamps. So when you say >2010-01-01 you are actually saying >'2010-01-01 00:00:00'. This mean you are effectively including Jan 1st because 00:00 is midnight.
Answered 02/12/2010 by: GillySpy
Seventh Degree Black Belt