Forum Discussion

im_92's avatar
im_92
Frequent Visitor
5 years ago
Solved

Convert text to date

Hi all,    I am trying to convert a text column to a date format.  The original column contains the date in this format: wednesday 2 october 2018.  I want to have a column with the date in this f...
  • jthomson's avatar
    jthomson
    5 years ago

    If you split the column by the first instance of a space, i.e. getting rid of the day of the week, does that get it into a close enough format that it can automatically recognise it's a date?

jthomson's avatar
jthomson
Solution Sage
5 years ago

If you split the column by the first instance of a space, i.e. getting rid of the day of the week, does that get it into a close enough format that it can automatically recognise it's a date?

  • Daviejoe's avatar
    Daviejoe
    Memorable Member
    5 years ago

    im_92   The explanation that jthomson provided is the simpler way of what I posted.

     

    Use a text delimiter of a space to remove the day of week and then you can format as a date.  

     

    Job done.

  • im_92's avatar
    im_92
    Frequent Visitor
    5 years ago

    that worked! Thanks!