Parsing dates

[rafael_rosado97]

Is there any way to parse a date column without Hours, Minutes and Seconds? I specified the format like MM/dd/yyyy, however, it appears. For example, after parsing 12/30/1899, it is showed like 1899-12-30T00:00:00.000Z. I just want 1899-12-30 only.

Thanks for your attention.

[Emma · Accepted solution]

Hey @rafael_rosado97, 

No, there is no way to parse the date without including the hours, minutes, and seconds. If you do any formatting your DATE will become a STRING type. 

If you do not mind the column becoming STRING type then you can achieve the formatting you want by adding one additional Prepare step called "Find and Replace" where you specify the parsed date column, the value you want to remove (in your case: T00:00:00.000) and no value in the Replacement. See the screenshot.

Hope that answers your question, 

Emma 

[rafael_rosado97]

It's very clear. Thank you for your prompt answer, @Emma 🙂