[AccessD] Date/Time Conversion

David,
Ha, Using "format" in the query is what was screwing it up.  

Thanks!!

Robert Gracie
www.gbsysnow.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Sunday, November 06, 2005 1:30 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Date/Time Conversion

I don't think you need the slashes in the date in the format function.

I was going to ask why are you even using the format function? I would
just put the criteria in the field and format the reports displayed
field.

HTH
David

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Robert Gracie
Sent: Sunday, November 06, 2005 9:39 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Date/Time Conversion




I have a table that has a date field that the input has been the date &
the time (Now()). I'm trying to build a report based on the results of a
query that the user inputs the date.

I have tried formatting the field by using "TransDate:
Format([DateOFMovement],"mm/dd/yyyy")", with the criteria "Between
[Start Date ie: 10/05/2005] And [End Date  ie: 10/06/2005]".

So if the users input is 01/01/2005 for the first date and 01/10/2005
for the second, the query results include 2004 records also, but with-in
the month and day criteria...

If I try to sort the results is ascending order on the date, it will
only sort on the month & day..

What am I doing wrong??


Robert Gracie
www.gbsysnow.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com