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")

AvaniAnand's avatar
AvaniAnand
New Contributor
7 months ago

How can I parse a string in an object to Date?

eg. Date.parse($vendorBill.tranDate, "dd-MM-YYYY") gives me NaN