How to block dataiku dataset from formatting date values?

[mi6crazyheart]

I've some date values which get automatically format when I pass that through dataiku dataset. I don't want to format those dates. I just want them in the same format in which they are before formatting.

Before formatting

After formatting

---

Operating system used: windows

[AlexT · Accepted solution]

Hi,

Is this an SQL dataset?

DSS would typically change the format automatically unless you parse the data in the prepare recipe.

https://doc.dataiku.com/dss/latest/preparation/dates.html

If you want to keep the original format simply change the type to "string" in your dataset schema instead of date type and DSS will keep it as a string or remove the Read SQL "date" as DSS option in the input dataset settings.

If you want to convert it from the parsed format back to MM/dd/yyyy you can do so with prepare processor( Format date with custom format) and se the type to string. 

 

Hope that helps!

[mi6crazyheart]

Hi AlexT,  Thanks for your reply. I've fixed this by mentioning the datatype of dataframe's columns names. 

Ex: bucketOutput_df = bucketOutput_df.astype({"bucketStatusDate": str, "bucketSpudDate": str})

By the way, I was reading the data from an EXCEL sheet.

I was reading from an EXCEL sheet & trying to put that to Dataiku dataset.