Problem with Dates

GerardMcL
10-25-2004, 11:16 AM
Hi,
I have a form with 2 textboxes - the user enters two dates and its supposed to retrieve all data between these dates.

Its the date format Im havin problems with

I enter the date below
25/10/04 17:05:00
I placed a MsgBox to see the sql statement but it shows up like

WHERE column BETWEEN '10/04/2025 17:05:00' AND .......

Why is this happening? I have created other forms that perform the same action and havent had this problem with them.

P.S. I read the values using selSDate = CDate(Text1.Text)
Is there a problem there?

Dennis DVR
10-25-2004, 11:41 AM
Perhaps it has something to do with your regional setting. Did you try to format the date with "dd/mm/yyyy"?

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum