/bundles/itninjaweb/img/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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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