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

Please log in to comment

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

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

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

Please log in to comment
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

Please log in to comment
Answer this question or Comment on this question for clarity