Format Now() Date

JudyMKE Registered Posts: 2 ✭✭

October 9 in Using Dataiku

In my recipe, I created a new column with Now(). I would like to format that date as 'mm-dd-yyyy'.

However, the result is:

Tagged:

• Chrome
• Enterprise
• Dataiku Version 12

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,090 Neuron

  October 9 edited October 9 Answer ✓

  The format uses the ISO-8601 standard so use MM-dd-yyyy (mm is minute of the hour in that standard). More info below:

  https://doc.dataiku.com/dss/12/formula/index.html#date-functions

  https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

  1 · Share on FacebookShare on Twitter

Answers

• 

  JudyMKE Registered Posts: 2 ✭✭

  October 9

  https://community.dataiku.com/discussion/comment/44657#Comment_44657

  Thank you so much.

  0 · Share on FacebookShare on Twitter