Login | Sign up | Toll-Free: 1-800-752-0455
 
 

Forum

 

3 posts by 2 authors in: Forums > CMS Builder
Last Post: June 20, 2016

Hi

One of the posts sort of covered off hiding expired dates (that is, only show dates from today onwards), post 2236900 but I must be doing something wrong.

// load records from 'whats_on'
list($whats_onRecords, $whats_onMetaData) = getRecords(array(
'tableName' => 'whats_on',
'orderBy' => 'DATE',
'loadUploads' => true,
'allowSearch' => false,
'where' => 'date' >= TIMESTAMP(CURDATE(), '00:00:00')",

));

That just results in an error.  Is this not valid in this circumstance?

Perfect, thanks so much.