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