Date Format in DataBrew transformation

0

Working with a CSV that has a date format on the raw file dd/mm/yyyy which is AU/UK format. Raw Date Field

We are applying a recipe to change the data format to yyyy-MM-dd via the format column transform so we can do some ordering via asc/desc.

But if I look at a before and after from the two text files.

Before = FOO 3822 08/03/2023 Bob (8th of March 2023)

After= FOO 3822 2023-08-03 Bob (3rd of August 2023)

This only seems to apply on string where the dd is between 1-12. So i'm getting a mixture in my output of some outputs being yyyy-MM-dd & yyyy-dd-MM with a single Date Function.

is their a way to parse the string as a date standard before I format it?

The dataset is a list of product price updates. There is multiple rows with the same product but different update date stamps. The purpose is to order them by latest date using the format yyyy-MM-dd and then remove duplicate rows for the same product leaving a dataset with only the latest product update which will always be the first row of the same product type.

AWS
Arran
asked a year ago115 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions