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

Still getting the same error 😞

  • jgeddes's avatar
    jgeddes
    Super User
    2 years ago
    Month_Year = 
DATEVALUE(
    FORMAT('Absence Data'[End], "MMMM YYYY")
)

    Does this get you the result you need? 

    • hallang's avatar
      hallang
      Frequent Visitor
      2 years ago

      Nope still getting the same error 😞

      • jgeddes's avatar
        jgeddes
        Super User
        2 years ago

        Alrighty. What happens when you use...

        FORMAT('Absence Data'[End], "MMMM YYYY")

        without wrapping it in the DATEVALUE()?