I have a field column with dates in this format 20070506. I need to convert this date to: 5/6/2007 with slashes but have the date appear as mm/dd/yyyy. Is there a quick conversion function to do this?
The date is formatted as a Number in Access from the Mainframe. I have placed your Expression in the criteria part as: DateSerial(mid([ABCDate],1,4)
,mid([ABCDate],5,2),mid([ABCDate],7,2))
Yet, when this is run, i get no results. Don't you need the "/" between & somehow?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.