Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Change Date type from MM/dd/yy hh:mm to yyyy-MM-dd
Added on February 20, 2025 6:23AM
Likes: 0
Replies: 2
Chetna
Registered Posts: 5 ✭✭
Hi, I have a "Invoice date" column in my source file which has values like "1/18/24 1:00". and I want it to change it as "2024-01-18"
Additionally, Dataiku is identifying this column as Text/String. How can I change it to the format mentioned above.
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,384 NeuronSee the following documentation page:
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,618 NeuronDates and times can be challenging in Dataiku. One of the key aspects of using dates and times in dataiku is that you have to parse them into a format that dataiku understands as a date time value. Generally recorded in GMT time. You specified the specified a very particular output format yyyy-mm-did. If you need exactly that for some process further down your flow or beyond. You will likely have to use the formula editor to extract the date parts and concatenation your final result. Be careful with this process. Time zones can cause you challenges.
I would tend to carefully parse the date time and output the results parsed in the standard way to the next steps in the process. And not try to reformat in a yyyy-mm-dd format for output. (That just me, and your situation may mandate a different approach. )