How to convert to date format?

Question

How to convert to date format?

Using Access 2003

Date Column type - text

Table 1

date

Expected Result

28-May-2009
29-May-2009
30-May-2009
02-May-2009
04-May-2009

...

How do I make a query for the format of the expected output date?

+2

vba datetime ms-access

Gopal 27 oct. '09 at 10:18

source to share

3 answers

I find that Cdate doesn't work for me.

Format(DateSerial(Left(Field1, 4), Mid(Field1, 2, 2), Right(Field1, 2)), "dd-mmm-yyyy")

+1

Fionnuala 27 oct. '09 at 10:47

source to share

CDate should do what you want ...

0

Irfy 27 oct. '09 at 10:22

source to share

heferav · Accepted Answer · 2009-10-27T10:34:57+0000

As VBA code - you can wrap it as a function

Dim strMyDate As String
Dim dteDate As Date

strDate = "20090528"
dteDate = DateSerial(Left(strDate, 4), Mid(strDate, 5, 2), Right(strDate, 2))
MyStr = Format(dteDate, "dd-mmm-yyyy")
Debug.Print MyStr

As a data type in a table . If you add data to a table where the field is Date / Time formatted you can specify the format in the form / table i.e. at the exit.

How to convert to date format?

More articles: