How to make a date ordered CB list with automatic record aging

17 years 11 months ago #13445 by zen
In the similar line with what's been discussed in this thread, I'm trying to figure out the following.

One of my tabs has a special deal info. This special deal has an expiry date and once the current date passes this expiry date, the deal no longer shows up on a custom user list that displays a series of special deals.

The only criterion I don't know how to create is this expiry date.

Please advise.

Please Log in to join the conversation.

17 years 11 months ago #13474 by nant

Please Log in to join the conversation.

17 years 11 months ago #13530 by zen
In case there's anyone looking for an answer to the same question I posted, the query to use is as below:

`cb_yourfieldname` >= CURDATE()

Please Log in to join the conversation.

17 years 9 months ago #16754 by wmike
This is probably a very silly question.

How do I actually display a list?

Cheers!

Mike

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.380 seconds

Facebook Twitter LinkedIn