Newbie Ist time query 1

[shibuyauk]

Hi, sory if this is a very basic question. I am not a programer/developer by trade, but have found a great need to use SQL reporting services. I simply want to extract all this data on just 1 day, what is wrong with my transact code?

Select *
FROM applyTracking
WHERE (hitDate <= '01-Apr-2005') AND (deal = 'true')

Its a long time since i did any of this, i dont understand why it wont work.
My hitdate table also uses seconds in the field, so when i just use '01-Apr-2005' it only finds records with a date stamp of '01-Apr-2005 00:00:00' no others
iS there a between comand i can put in there? If so what is the syntax

Also it doesnt like AND (deal = 'true') at all, is the syntax wrong there?

Thanks for any help for a N00b!

 

[shibuyauk]

Thanks James, you are a saint

Cheers