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)
