Forum Discussion

hallang's avatar
hallang
Frequent Visitor
2 years ago
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 -

 

can anyone help with this?

Thanks

 

Need Help
  • jgeddes's avatar
    jgeddes
    2 years ago

    The null values are the issue. 
    So let's try this...

    Month_Year = 
DATEVALUE(
    IF(
        ISBLANK([End]),
        BLANK(),
        FORMAT([End], "MMMM YYYY")
    )
)

10 Replies