Søgning på dato

er det sådan du har prøvet:

select * from tabel where dato like '%23/1/2002%'

sludder

select * from tabel where dato like '%1/23/2002%'

sådan noget lignende ja - prøvede også med #, men fik fejl :o/

You should ALWAYS use the U.S date format when working with dates. This is
MM-DD-YYYY

So should work for 23 January 2002
SELECT * FROM YourTable WHERE TheDateField = '01-23-2002'
If that gives a problem then it is most probably becuase you have a time in the field too.
So try
SELECT * FROM YourTable WHERE TheDateField BETWEEN '01-23-2002 00:00' AND '01-23-2002 23:59'

I do use the U.S date format, and your suggestion did work, so thank you very much!

Hi luzk!
What was it that helped, did you need to use BETWEEN?

Oh! and thanks :o)

Hi terry. Yeah I tried to use LIKE, to find the users who logged in on a specified day, even though I know LIKE is used on TEXT, but now I am able to use BETWEEN instead :o)