Forum Discussion

rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

Hi Anonymous -create a calculated column that replaces the text values with a specific date

 

EOS Date Cleaned =
IF(
ISERROR(DATEVALUE([EOS date])),
BLANK(),
[EOS date]
)

 

Hope it works

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I did the formula above and is getting me error:

     

     

     

    the EOS Date column has values as such below:

     

    • rajendraongole1's avatar
      rajendraongole1
      Super User
      2 years ago

      Hi Anonymous - Can you try below calculated column

       

      EOS Date Cleaned =
      VAR IsValidDate =
          NOT(ISERROR(DATEVALUE([EOS Date])))
      RETURN
          IF(
              IsValidDate,
              DATEVALUE([EOS Date]),
              DATE(1900, 1, 1) // or BLANK() if you prefer
          )

       

       

      with Blank()

       

       

       

      Hope it works

       

      Did I answer your question? Mark my post as a solution! This will help others on the forum!
      Appreciate your Kudos!!

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        that worked. thanks.. 🙂