Converting string format to Date format

2 followers
0
Avatar

Hi there,

I am learning datameer. I have a date column in string format.

dob_column

5/Dec/1985

10/Jan/1990

 

I want to convert the dob_column to date format in datameer(worksheet).

I am trying this function =ASDATE(#dob;"dd/MMM/yyyy") in formula bar, but gives error

 

Thanks,

Jee

 

Jee Answered

2 comments

  • Avatar
    Alan Mark

    Hi Jee,

    I created a test csv with your dates and got it to work by changing your double quotes "" to single quotes ''.

    ASDATE(#DOB;'dd/MMM/yyyy')

    Alan

    0
    Comment actions Permalink
  • Avatar
    Jee

    Hi Alan,

    Thanks for your support.

    It works ASDATE(#personal_Details_txt!dob;"dd/MMM/yyyy")

     

     

    0
    Comment actions Permalink
Post is closed for comments.