var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: select records with expiry date = current month (was "Simple SQL question...")
I have a database that contains a field 'ExpiryDate' in format dd/mm/yyyy. I need to write an sql statement to select records with expiry date = current month
Depends on your RDBMS. Something like:
might do it
WHERE Month(ExpiryDate) = Month(Date()) AND Year(ExpiryDate) = Year(Date())
ur codings are working excelent.
Thanks Pootle Flump
Even though it was posted ages ago was just what I needed.