Date conversion

[genious]

I am importing a csv file with a date field.  My problem is that the date field is in USA format(m/d/yy).  How do I change this to a European format(DD/MM/yyyy)?  I have looked for a function but to no avail.  Thought of the left function but this is never consistent as US dates can have 1/1/2012 or 10/10/2012.  How should I do this?

[Lee Smith]

Let([

Parts=Substitute(YourDateField;"/";" ");

Day=MiddleWords(Parts;2;1);

Month=LeftWords(Parts;1);

Year=RightWords(Parts;1)];

Day &"/"& Month &"/"& Year)

[genious]

Many thanks Lee,

 

I have yet to learn this side of the calculation engine as I haven't been active for the last few years.

 

M