How do I convert "yyyymmdd" to "mm/dd/yyyy via a query

D

DZ

How do I convert "yyyymmdd" to "mm/dd/yyyy" via a query. I cannot change the
field properties in the table.
 
K

Klatuu

What is the data type of the field your working with? A Date/Time data type
does not present in yyyymmdd format?
 
S

scubadiver

It is worth posting what you did. Then others who have similar queries can
find the answer easily.
 

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

Convert yyyymmdd format to dd-mm-yyyy 4
Append/Update Query 6
Convert Date 3
Convert Date 1
Excel date format YYYYMMDD 1
HOW TO CONVERT DD-MM-YY to YYYYMMDD IN ACCESS DATABASE? 1
Converting a YYYYMMDD field into 3 fields YYYY MM and DD 2
convert date format from mm/dd/yyyy to dd/mm/yyyy 3

Top