converting text to data format

[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

 

[Pieter Wijnen]

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

HTH

Pieter

 

[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.

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

HTH

Pieter

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

 

[Pieter Wijnen]

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

Pieter

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

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

HTH

Pieter

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

 

[Guest]

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

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

Pieter

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

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