Date Search in Date & Time Field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

Wonder if someone can help me please.

I have a date and time field which shows the dates and times that files were
received onto a server at work. This is in the format of DD/MM/YYYY HH:MM and
comes in the form of a .csv file which I then import into the database.

The problem I have is that once loaded into the database, I need to search
within this field for files received between two user selected date
parameters. At the moment I am taking out the time element whilst in excel
but this is becoming a bit of a pain.

Can anyone tell me please how can I keep the 'raw' data as it is but also
enable a user to search between the two dates that they want to retrieve the
records for.

Thanks very much

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: Reserved words
    ... Perth, Western Australia. ... Tips for Access users - http://allenbrowne.com/tips.html ... > I am making some changes to a database that I didn't create and ran into a ... > doesn't work because of the Time field. ...
    (microsoft.public.access.formscoding)
  • how to break the bounds of 59 in data/time data type
    ... when i select "Data/Time" data type for my time field then ... this format gives the liberty to record times uptill a figure of 59 in ... i am a very basic user of access or for that matter any database. ...
    (microsoft.public.access.queries)
  • how to break the bounds of 59 in date/time data type
    ... when i select "Data/Time" data type for my time field then ... this format gives the liberty to record times uptill a figure of 59 in ... i am a very basic user of access or for that matter any database. ...
    (comp.databases.ms-access)
  • Query Log Start Time 5 hours ahead
    ... I set up the query log to write to a database and it is capturing data ... but the start time field is 5 hours ahead of the real time. ...
    (microsoft.public.sqlserver.olap)
  • Re: Master Contact Database
    ... We have the Microsoft Windows Server 2003 for Small Business Server and the ... we also have this all on an Excel ... spreadsheet for use with a database and the web and for sorting; ... Access or other programs query against them. ...
    (microsoft.public.office.misc)