date problem

[charvi]

i have a problem with dates i want to retrieve some records between two dates dates are input to two masked box.i have written the query like this
rssearch.Open "select * from timesheet where sname like'%" & txtstaffname.Te xt & "%'" & _
"and date =#" & mskfrom & "#", con, adOpenDynamic, adLockOptimisti c
if mskfrom value is 01/01/2008 and msk is 04/01/2008
it gives result of four months but i want only jan 4 days result
pls help me database is msaccess

[lotus18]

i have a problem with dates i want to retrieve some records between two dates dates are input to two masked box.i have written the query like this

[code=vb]
rssearch.Open "select * from timesheet where sname like'%" & txtstaffname.Te xt & "%'" & _
"and date =#" & mskfrom & "#", con, adOpenDynamic, adLockOptimisti c

[/code]
if mskfrom value is 01/01/2008 and msk is 04/01/2008
it gives result of four months but i want only jan 4 days result
pls help me database is msaccess

Hi

As i can see it seems like that the date format must be Day/Month/Year and not Month/Day/Year . You need Format function for that : )


Rey Sean

[charvi]

Hi

As i can see it seems like that the date format must be Day/Month/Year and not Month/Day/Year . You need Format function for that : )


Rey Sean

i used format function but still it is not working

[lotus18]

i used format function but still it is not working

May I see the codes.BTW, have you checked the format of your date on your database?

Rey Sean

[charvi]

May I see the codes.BTW, have you checked the format of your date on your database?

Rey Sean

but in database it stores in dd/mm/yyyy.but only after executing the query it compares with mm/dd/yyyy i used format function also
can any one help

[charvi]

but in database it stores in dd/mm/yyyy.but only after executing the query it compares with mm/dd/yyyy i used format function also
can any one help

i have coded like this and my database stores data in dd/mm/yyyy format
but when i enter dates in textbox in dd/mm/yyyy format
for eg 01/01/2008 and 04/012008
here it compares o4 as month
and gives result upto april but iwant records till jan 4
can any one help

[mafaisal]

Hello,

U Have Better to Use DTPicker to Select Date instead of textbox

Faisal

i have coded like this and my database stores data in dd/mm/yyyy format
but when i enter dates in textbox in dd/mm/yyyy format
for eg 01/01/2008 and 04/012008
here it compares o4 as month
and gives result upto april but iwant records till jan 4
can any one help

[charvi]

Hello,

U Have Better to Use DTPicker to Select Date instead of textbox

Faisal

i used msk editor i cannot use date picker because some times a vaule is not entered

[lotus18]

Can you post some of your codes here?

What do you mean by this?

i used msk editor i cannot use date picker because some times a vaule is not entered

You can do a validation for that.

[9815402440]

hi

open control panel and then open regional and language settings. here change short date format to dd/MM/yyyy.
this will solve your problam

regards
manpreet singh dhillon hoshiarpur

[Killer42]

Actually, it's quite simple. The database does not store dates in dd/mm/yyy, or mm/dd/yyyy, or any other such format. It simply stores a number. The formatting is only used in passing values to and fro, since they have to be placed in a string, and need to make sense to the reader.

The SQL interpreter (at least for Access, not sure about other DBMSs) requires American format. So take your date value and format it as mm/dd/yyyy when placing it in the SQL's WHERE clause. You can display it in whatever format you like. Generally it's best to use the Windows settings if possible, so that the end-user is not locked into what you consider the right format.

Where possible, I recommend using a less ambiguous format to prevent this sort of issue. For example, dd-mmm-yyyy (Eg. 21-Jan-2007). There's not much chance of getting the day and month mixed up in this case.

Manpreet, I think expecting everyone to set their Windows date format the same seems a bit unreasonable.

[debasisdas]

i used msk editor i cannot use date picker because some times a vaule is not entered

You can use the checkbox option of the control.