Convert from Long Date

[air1access]

I have a text field value that I need to convert from December 11, 2014 3:58 PM to 12/11/2014 3:58 PM

Any suggestions or examples.. I'm stumped..!!
Thanks in advance..!!!
jcw5107

 

[Andrzejek]

How about:

Dim strDate As String

strDate = "December 11, 2014 3:58 PM"

Debug.Print [blue]Format(CDate(strDate), "MM/DD/YYYY hh:mm AMPM")[/blue]

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[air1access]

I tried that... I can't get it to work...
Just get #Error as the result...

 

[dhookom]

I get exactly the expected results from Andy's suggestion.
How did you attempt to implement his expression?
Do you have any Nulls in your data?
Are all of your text values consistent in format?

Duane
Hook'D on Access
MS Access MVP

 

[air1access]

Sorry about that..
I didn't realize there were extra characters in the value... Duhhh...!!
What Any suggested works perfectly. My bad..!!

Jw