Forum Discussion
Solved
Changing text to date column not working
Hi, I have added in a formula to convert a column from DD MMMM YYYY to MMMM YYYY. I have added a column to do this but when I try and change the data type to 'Date' its saying it cannot convert it ...
The null values are the issue.
So let's try this...Month_Year = DATEVALUE( IF( ISBLANK([End]), BLANK(), FORMAT([End], "MMMM YYYY") ) )
You can absolutely change the column type to date. Based on the continued reappearance of the error I am thinking that there is/are values in your 'End' column that are not playing nice.
Your initial screen shot did not contain any data in the 'End' column so I have been making assumptions that the data in the 'End' column was sound. My suggestion at this point would be to review the contents of that column to ensure that there are no anomalies.
so the 'end' is a date field, the only thing I can see in it is it has 'null' values but it needs to as on some rows this will be blank