converting text to data format

G

Guest

I have dates in text format from an external source in an Access Table.
I have used DateValue, Cdate and DateSerial and format syntax in a query all
of which seem to result in dates,
however,
When I use 'Between [date]and[date]' as criteria it appears to still be in
text format because I dont get a correct filter. Any ideas

Thanks, Peter Farrington
 
P

Pieter Wijnen

If Dates contain Time as well
try
Between FromDate And ToDate + 1 - 1/86400

HTH

Pieter
 
G

Guest

The original text is typically 23/02/2007. DateSerial should only bring year,
hour, minute data into the query result and displays as such.

Pieter Wijnen said:
If Dates contain Time as well
try
Between FromDate And ToDate + 1 - 1/86400

HTH

Pieter


Peter Farrington said:
I have dates in text format from an external source in an Access Table.
I have used DateValue, Cdate and DateSerial and format syntax in a query
all
of which seem to result in dates,
however,
When I use 'Between [date]and[date]' as criteria it appears to still be in
text format because I dont get a correct filter. Any ideas

Thanks, Peter Farrington
 
P

Pieter Wijnen

DateSerial ought to do it then
What version of Access? What is the db type of the external source?

Pieter


Peter Farrington said:
The original text is typically 23/02/2007. DateSerial should only bring
year,
hour, minute data into the query result and displays as such.

Pieter Wijnen said:
If Dates contain Time as well
try
Between FromDate And ToDate + 1 - 1/86400

HTH

Pieter


Peter Farrington said:
I have dates in text format from an external source in an Access Table.
I have used DateValue, Cdate and DateSerial and format syntax in a
query
all
of which seem to result in dates,
however,
When I use 'Between [date]and[date]' as criteria it appears to still be
in
text format because I dont get a correct filter. Any ideas

Thanks, Peter Farrington
 
G

Guest

Sorry Pieter. my drive packed up. Will write again in a few days

Pieter Wijnen said:
DateSerial ought to do it then
What version of Access? What is the db type of the external source?

Pieter


Peter Farrington said:
The original text is typically 23/02/2007. DateSerial should only bring
year,
hour, minute data into the query result and displays as such.

Pieter Wijnen said:
If Dates contain Time as well
try
Between FromDate And ToDate + 1 - 1/86400

HTH

Pieter


message I have dates in text format from an external source in an Access Table.
I have used DateValue, Cdate and DateSerial and format syntax in a
query
all
of which seem to result in dates,
however,
When I use 'Between [date]and[date]' as criteria it appears to still be
in
text format because I dont get a correct filter. Any ideas

Thanks, Peter Farrington
 

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

Top