-   Programming (
-   -   Working within content management system, how to sort with date >= today? (

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:

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

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


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


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!

All times are GMT -5. The time now is 08:11 PM.