Forum Discussion

ldwf's avatar
ldwf
Helper V
1 year ago
Solved

Convert text to date when text has blanks

I have a date field that is defined as text.  I need to convert it to a date field by creating a new calculated field, but some of the records have blanks in this date field, so the simple conversion...
  • PhilipTreacy's avatar
    1 year ago

    ldwf 

     

    Try this

     

    Date Field = IFERROR(DATEVALUE([Text Date]),BLANK())

     

    Regards

     

    Phil