LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Programming (http://www.linuxquestions.org/questions/programming-9/)
-   -   Working within content management system, how to sort with date >= today? (http://www.linuxquestions.org/questions/programming-9/working-within-content-management-system-how-to-sort-with-date-%3D-today-740576/)

mitchell7man 07-16-2009 01:21 PM

Working within content management system, how to sort with date >= today?
 
Okay, so I'm administrating a website under the restrictions of a content management system, not even sure which one it is. I've been trying to figure out what system it is to find syntax and other info or a wiki. Anyhow it has what it calls "supplementary tables" and under this tab you add column names and types. Once you make a table you can make a "Display Module" with sorting statements and condition statements.

condition statements are to be formatted like this:
Quote:

Conditions may be compounded by using the AND and OR keywords.
Examples:

statement1 AND statement2
Both statements must be true
statement1 AND (statement2 OR statement3)
Statement 1 must be true and either of statements 2 or 3
hopefully this gives some insight to someone as to what exactly this system is using, it looked like some code i've seen before.

Anyway, I want to have a date-time variable and be able to condition the display to only show >= todays date, how to do this?

Thanks for any help you can offer.

Dan04 07-17-2009 11:23 PM

Assuming that the condition statements are SQL WHERE clauses, you want

Code:

date(YourColumnName) >= date(now())
or

Code:

date(YourColumnName) >= date('now')
Otherwise, I have no idea. Your post didn't give me anything useful to Google for.

mitchell7man 07-18-2009 02:04 AM

Lol, yeah it was an interesting thing to figure out, I had to browse through tables others had made, it ended up being NOW()

Thanks for the help!
MJ


All times are GMT -5. The time now is 06:25 AM.