Text convert to Date

[tomtom1126]

Hi, I am the junior of the ms access.

I try to convert the below text to date
(03/08/2015 19:42)
(31/07/2015 12:20)

CDate([XXXX])
reture 3/8/2015 7:42:00 PM (should be 03Aug2015)
reture 7/31/2015 12:20:00 PM (should be 31Jul2015)

anyone can help, please.

Tom

 

[arnelgp]

Format(CDate([XXXX]), "ddmmmyyyy")

 

[tomtom1126]

Dear arnelgp

Thanks for your feedback, but result still not correct

Format(CDate([XXXX]), "ddmmmyyyy")
(03/08/2015 19:42)
(31/07/2015 12:20)

return 08Mar15
return 31Jul15

Regards
Tom

 

[arnelgp]

maybe has to do with Regional setting of your date.

 

[tomtom1126]

thanks it's done.

another question on import excel file with special heading (abc.) or (123.)
not sure here is the right place to ask.

thanks again
Tom