how do you change a date format like this one

#1

I got some data that has the dates as 10/24/02
But its yyyy/dd/mm

so its FEB 24, 2010 but access sees this as 10/24/2002

I tried format([DateFieldName], "dddd mmmm yyyy")
it says you can't format this date invalid syntax.

this seems simple just re arrange the data. is that what I will have
to do is cut this string up and reformat it?

#2

"sparks" <sparks (AT) home (DOT) com> wrote

Quote:

I got some data that has the dates as 10/24/02
But its yyyy/dd/mm

so its FEB 24, 2010 but access sees this as 10/24/2002

I tried format([DateFieldName], "dddd mmmm yyyy")
it says you can't format this date invalid syntax.

this seems simple just re arrange the data. is that what I will have
to do is cut this string up and reformat it?

Try "dd mmm yyyy"

#3

Stuart McCall wrote:

Quote:

"sparks" <sparks (AT) home (DOT) com> wrote in message
news:1or696dh355m48hvpfbcn3puh7fqcep5gr (AT) 4ax (DOT) com...

I got some data that has the dates as 10/24/02
But its yyyy/dd/mm

so its FEB 24, 2010 but access sees this as 10/24/2002

I tried format([DateFieldName], "dddd mmmm yyyy")
it says you can't format this date invalid syntax.

this seems simple just re arrange the data. is that what I will have
to do is cut this string up and reformat it?

Try "dd mmm yyyy"

Maybe

? dateSerial(Left("10/24/02",2),right("10/24/02",2),mid("10/24/02",4,2))

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

how do you change a date format like this one

comp.databases.ms-access comp.databases.ms-access

how do you change a date format like this one - 09-17-2010 , 08:41 AM

Re: how do you change a date format like this one - 09-17-2010 , 12:07 PM

Re: how do you change a date format like this one - 09-17-2010 , 03:29 PM