date error

[sam_nik12345]

my data looks like below:

month	value
jan'18	1
feb'18	1
mar'18	1
apr'18	1

Here monh column is in text type and when I try to change to date type, I get all errors. How do I fix this?

Kinldy help.

[amitchandak]

@sam_nik12345 , I would prefer to create a date column  like

DATEVALUE("01 " &[Month])

or

DATEVALUE("01-" &left([Month],3) & "-"& right([month],2))

[sam_nik12345]

Hi @amitchandak 

I am getting error while creating a custom column with the formula-

= DATEVALUE("01 " &[Month])

[amitchandak · Accepted solution]

@sam_nik12345 ,  Try the other option suggested

Column = DATEVALUE("01-"& left([month],3) & "-" & RIGHT([month],2) )

[sam_nik12345]

@amitchandak 

The other table is as below, on which I am getting error with this formula. week column format is text type. Kinldy help.

week	value
3-Apr-18	1
10-Apr-18	1
17-Apr-18	1
24-Apr-18	1