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

mitchell7man · 07-16-2009, 12:21 PM

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, 10: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, 01: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