Importing Dates

[cknudsen01]

Hi Everyone,

I'm having trouble importing dates into my database. I'm importing from a tab separated text file into a date field. The problem is that the date in the text file is a different format from my system.

i.e. the text file is month/day/year and my system is day/month/year

Once the data is imported, I can't seem to work with it like a normal date because it's been imported wrong.

Does anybody have any suggestions?

Christian

Toronto, Canada

[The Bridge]

You could import the Date as formatted into a temp text field, then use this calc to convert the imported date to your system format:

Date =

TextToDate(MiddleWords(Substitute(Date_As_Text, "/", " "), 2, 1) & "/" &

LeftWords(Substitute(Date_As_Text, "/", " "), 1) & "/" &

RightWords(Substitute(Date_As_Text, "/", " "), 1))

Date_As_Text is the field you've imported the "faulty" dates into.

Hope this helps!

[cknudsen01]

Thanks Peter!

Cheers,

Christian