Date Conversion

[ChrisO]

Nigel.

From post #1 in this thread…
>>A couple of the fields are date formats but the source data has them has dd.mm.yyyy<<

And that is the specification as supplied by Andrew.

Chris.

 

[nanscombe]

In other words convert from dd.mm.yyyy to dd/mm/yyyy which is why I initially said that the OP could also try a different method which would not require any coding.

It could be tried and, if it did what was required, then all well and good. If it failed there is still the function to use.

 

[Pat Hartman]

The import dialog handles dates in many formats. When the dialog opens, click the advanced button. To get to the place where you can set the date format. Choose the dmy option and the dot as the separator

Then scroll through the columns and change the data type to date (you may be able to do this in the first dialog where you set the date by changing text to date as the data type.

Then looking at the table it shows the date as m/d/y because that is my system date format.

No coding required if you do it when you import the data. You can save the import spec and then reference it in the TransferText method to automate the task.