MS query returning wrong dates

[stevecox]

Hi, I am trying to return records from an SQL database using MS query in Excel. I only want records after my chosen dates but keep getting records from before as well.

I have used the greater than or equal to comparison in my query for the date criteria but it still returns dates previous to this in my table. My date format is DD/MM/YYYY and is in text format in the SQL database

I used: >=[startdate]

Any clues as what i can do?

Thanks

Steve

 

[Special-K99]

Could this have something to do with the way Excel stores dates internally?
Maybe you need to convert the SQL date to a "readable format" before the comparison?

 

[stevecox]

Thanks for the reply; i believe the comparison happens in MS Query before it is loaded into the table in Excel, so I think it is trying to compare dates as text; i.e how they are stored in the SQL database. I cannot change this as other users are using it for other reports.

I may need to convert the txt date to a number date in an expression in y query but dont know how? Yet