Date Range Query

B

Brad

Hello, I'm trying to perform a query on a set of data over a date
range. The date field is in a date/time format of seconds starting
from 00:00:00 01.01.1970. Does anyone know how I can easily convert
this into "human" form? What expression/function might I be able to
use in my query to get data, for example, from Feb. 1, 2005 - Feb. 28,
2005. I'm using MS Access 2000.
 
V

Van T. Dinh

Try:

CDate(Replace(Mid(strDate, 10), ".", "/") & " " & Left(strDate,8))

From the Debug window:

strDate$ = "01:23:45 01.01.1970"
?CDate(Replace(Mid(strDate, 10), ".", "/") & " " & Left(strDate,8))
01/01/1970 01:23:45
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a Query that Prompts for Date and Time 4
Counts number of entries per day in query 4
Query to find records after specific date and time today 10
Changing constants in a query to user input values 2
Numeric Field Overflow when appending date - how to convert it to text 1
Date() update format 5
Query date/time issues 1
TYPE CONVERSION 1

Top