subject:"my final 1064 error"

Re: my final 1064 error

2009-04-22 Thread Peter Brawley

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 MS

my final 1064 error

2009-04-22 Thread Matthew Stuart

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