Matthew
>SELECT Vouchers.VoucherID, Vouchers.VoucherCode, Vouchers.StartDate,
Vouchers.EndDate, Vouchers.Discount, Vouchers.VoucherTypeID
>FROM Vouchers
>WHERE (((DateDiff('d',[StartDate],Date()))>=0) AND
((DateDiff('d',[EndDate],Date()))<=0));
Square brackets and your DateDiff syntax are MSSQL, not MySQL.
PB
-----
Matthew Stuart wrote:
> Here is my final problem that I am struggling to overcome...
>
>
> SELECT Vouchers.VoucherID, Vouchers.VoucherCode, Vouchers.StartDate,
> Vouchers.EndDate, Vouchers.Discount, Vouchers.VoucherTypeID
> FROM Vouchers
> WHERE (((DateDiff('d',[StartDate],Date()))>=0) AND
> ((DateDiff('d',[EndDate],Date()))<=0));
>
>
> Basically, the error is on the WHERE line of the query, and I assume
> it is something to do with the DateDiff, but I don't know if there is
> a MySQL equivalent. Also, is Date() valid MySQL?
>
> Thanks.
>
> Mat
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.238 / Virus Database: 270.12.2/2074 - Release Date: 04/22/09 08:49:00
>
>
