Parsing dates

Solved!
rafael_rosado97
Level 4
Parsing dates

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.

0 Kudos
1 Solution
Emma
Dataiker

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 

View solution in original post

2 Replies
Emma
Dataiker

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
Level 4
Author

It's very clear. Thank you for your prompt answer, @Emma ๐Ÿ™‚