Dates format

Dear All,
I would like to compare a selected Date with a range of dates in sqlserver database.
The date format is dd/mm/yyyy and computer system date is also the same.
but the problem is when i run the query it doesn't return a result but if
the matching date was in the format mm/dd/yyyy the query will return the
date.

the database collation is latin_general.

I need the query to match the date format dd/mm/yyyy

so how can i solve the problem??

You can use DatePart or Month, Day, Year concatenated to make your needed format. Or you can Cast or Convert it the the date format you need. All can be done in the sql query.

Quote:

---

Originally Posted by Octopus

Dear All,
I would like to compare a selected Date with a range of dates in sqlserver database.
The date format is dd/mm/yyyy and computer system date is also the same.
but the problem is when i run the query it doesn't return a result but if
the matching date was in the format mm/dd/yyyy the query will return the
date.

the database collation is latin_general.

I need the query to match the date format dd/mm/yyyy

so how can i solve the problem??

---

Dates are displayed in those formats.

In MS SQL dates are stored as integer values.

Your problem is related to how you are formatting dates between VB and the query.

Show some code and we can deal with the actual issue.