GerardMcL
10-25-2004, 10: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?
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?