Forum Discussion
Solved
Convert column from Text to Date
Ok I have a column in my data that has the year and month of an item captured. The issue is that it is a text field that lists it as text in this format: YYMM I know I could split these and rec...
Are all the years in the 2000s ?
you may have to modify the above if your column is only the last 2 year digits - YYMM
Column = DATE("20"&LEFT([Test],2), RIGHT([Test],2), 1)
If the column is called [Test] and if the format is YYYYMM, I generally do
= DATE(LEFT([Test],4), RIGHT([Test],2),1)
Careful about the year though. In your case, you only have YY instead of YYYY, so might have to concatenate 19 or 20 based on what you want.
