Click to See Complete Forum and Search --> : Report generation


priyam
08-27-2008, 01:01 AM
Hi i have attached a word file in this post please have a look at it and let me know if any body could help,i would be really greatful.

Its about a report generation tool on which i am working,i have to retrieve data from database between 2 specified dates,but i am unable to do it even by using between clause

Please help

sayfrndship
09-03-2008, 02:14 AM
Do convert your field to datetime format datatype. and try this

select * from report where dt between #08/01/2008# and #08/31/2008#

priyam
09-03-2008, 04:26 AM
Thanx for your help...but i have figured out the actual problem.
The data in my database is stored in the format m/dd/yyyy and my search string contained date in mm/dd/yyyy for e.g date in database is 8/01/2008 but i was searching for 08/01/2008..the problem was with the format of the month.

sayfrndship
09-04-2008, 05:02 AM
Is it got alright now ?

priyam
09-05-2008, 02:40 AM
Yes :)