Convert text to datetime

[kaledev]

I have seen a post or two about this but the answers were a bit too specific to the exact date so I couldn't figure it out.

I have a column of dates set as text in the format yyyy-mm-dd, but I need to convert this to datetime as a short date (dd/mm/yyyy).



Any ideas? Thanks!

[RuralGuy]

Have you tried using the DateSerial() function?

[kaledev]

Have you tried using the DateSerial() function?

Thanks :-), I used that with the Mid function and it worked perfectly.

[RuralGuy]

Great! Are you ready to use the Thread Tools and mark this thread as Solved?