Forum Discussion

guyatisk's avatar
guyatisk
Icon for Helper II rankHelper II
3 years ago
Solved

Dataflow date with 00/00/0000

In a dataflow I am creating, I ran into the error: "We couldn't parse the input provided as a Date value. Details 00/00/0000".  Looking at the incoming csv file, this is coming from a DOB (Date of birth) column, where some have data.  I am assuming data entry is made this way when the birthdate is unknown.  What would be a good way to handle this?  Is it a simple search and replace (with something like '01/01/1900')?

2 Replies

  • cassidy's avatar
    cassidy
    Icon for Power Participant rankPower Participant

    If you know "00/00/0000" is consistent, then yes you could add a Replace Values step to "01/01/1900" or even probably blank if that works better for you.