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 ...
sam_nik12345 , Try the other option suggested
Column = 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) )
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