Hello,

I have a problem in selecting time from query my computer language is in Norwegian. I am using visual basic 6 with msaccess.

when I use Jan,Feb,Mar,Apr as month query gives me the correct resule but when I use May it gives me a error message. I thing it is because of language.
Because May = mai in Norwegian.

sql = "select distinct format(ms.match_Date_Time,'hh:mm:ss') from Season s,leauge l,Match_Schedule ms where s.Season_Id=ms.Season_Id and s.Season_Year=" & cmb_Season_Year.Text & " and l.leauge_Id=ms.Leauge_Id and l.Leauge_Name='" & cmb_Leauge_Name.Text & "' and format(ms.match_Date_Time,'dd.mm.yyyy')=#" & Format(cmb_Date.Text, "dd-mmm-yyyy") & "# and NOT EXISTS( SELECT schedule_Id FROM Match WHERE Schedule_Id = ms.Schedule_Id ) order by format(ms.match_Date_Time,'hh:mm:ss')"

can any one help me in this regard?

Regards,

Fawad Munir

You have to use the US format. Otherwise you're comparing strings.

Can you give any example of that if possible?thanks.
Regards,
Fawad

us date format is mm/dd/yyyy
alternatively you may get away with ISO date format YYYY/DD/MM
literal dates shouyld be encapsualted with a # symbol

yes I am using us date format but when I set. the format mm/dd/yyyy in msaccess it show date like this in database dd.mm.yyyy and when I select that date using query, it gives me the sytax error in date format. If possible can you send me any example in which I can see whole process. I will be very thankful to you.