Here's how I'd do it:
SELECT * FROM customers WHERE Site='egebjergnet' AND
TO_DAYS(NOW()) - TO_DAYS(date_column) = '45'
where date_column contains record dates...
Martin
Dan Eskildsen [EMAIL PROTECTED] wrote in message
9crq7l$mfb$[EMAIL PROTECTED]">news:9crq7l$mfb$[EMAIL PROTECTED]...
IT works!
Thanks!
martin helie [EMAIL PROTECTED] skrev i en meddelelse
9crqud$voj$[EMAIL PROTECTED]">news:9crqud$voj$[EMAIL PROTECTED]...
Here's how I'd do it:
SELECT * FROM customers WHERE Site='egebjergnet' AND
TO_DAYS(NOW()) - TO_DAYS(date_column) = '45'
where date_column contains