Forum Discussion
Solved
date error
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.
sam_nik12345 , Try the other option suggested
Column = DATEVALUE("01-"& left([month],3) & "-" & RIGHT([month],2) )
4 Replies
sam_nik12345 , I would prefer to create a date column like
DATEVALUE("01 " &[Month])
or
DATEVALUE("01-" &left([Month],3) & "-"& right([month],2))Hi amitchandak
I am getting error while creating a custom column with the formula-
= DATEVALUE("01 " &[Month])
sam_nik12345 , Try the other option suggested
Column = DATEVALUE("01-"& left([month],3) & "-" & RIGHT([month],2) )
