date problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Trever B - 18 Aug 2005 02:13 GMT

have a text field that contains dates how do I turn into date format?

eg

from 26.05.05 to 26/05/2005

I tried

datecorrect = Format([dateimp],"dd/mm/yyyy")

dateimp = 26.05.05

thanks in advance

Reply to this Message

Graham Mandeno - 18 Aug 2005 03:11 GMT

Hi Trever

Assuming you have a date format of dd/mm/yy in your computer locale
settings, this should work:

CDate( Replace( [dateimp], ".", "/" )

Replace changes the dots to slashes and CDate converts the result to a
date/time data type.

Signature

Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

> have a text field that contains dates how do I turn into date format?
>
[quoted text clipped - 9 lines]
>
> thanks in advance

Reply to this Message