Forum Discussion

BigUrn's avatar
BigUrn
New Contributor
3 years ago
Solved

Changing poorly formatted date into a clean date

I’m working on creating a few pipelines to transform some data, but I’m having an issue with the date field. The date field I pull is a string and not a date which is the main issue. It’s formatted a...
  • bojanvelevski's avatar
    bojanvelevski
    3 years ago

    I’m updating the expression:

    I’ve tested this one:

    Date.parse("Oct '22", "MMM ''yy")

bojanvelevski's avatar
bojanvelevski
Valued Contributor
3 years ago

Hi @BigUrn,

There’s an option within the Date.parse(), to let the function know the specific format, by passing an additional argument.

If the day is not relevant, you can try something like this:

Date.parse("01 " + $date, "dd MMM 'yy")