Forum Discussion

NAl's avatar
NAl
Contributor
5 years ago

Cannot format date correctly to YYYY-MM-DD

Hi there, I’ve looked at other articles addressing this but non has helped me so far. Im looking to format a date in the DD/MM/YYYY to YYYY-MM-DD. The date will always be populated. I’ve trie...
date
expression_language
tlikarish's avatar
tlikarish
Employee
5 years ago

The second argument to parse is the format that the string is expected to be in and that’s why you get the 0006-04-18 result.

Here’s an example pipeline to try out. It includes a mapper with the expression @bojanvelevski mentioned and also another method using the Date Time Extractor snap from the ML Data Preparation snap pack.

date-example_2021_04_09.slp (7.0 KB)

  • NAl's avatar
    NAl
    Contributor
    5 years ago

    How do I open the sample pipeline in Snaplogic? The file downloads to my desktop and cannot find the appropriate application to open it. I’m a newbie with SnapLogic so still trying to find my feet.

    • shubhisharma's avatar
      shubhisharma
      New Contributor
      5 years ago

      You should use import option from designer to import this sample pipeline directly to your Snaplogic.

    • SpiroTaleski's avatar
      SpiroTaleski
      Valued Contributor
      5 years ago

      @NAl

      Click on “Import a Pipeline” button, and then open/select the appropriate sample pipeline that you want to import.

      Regards,
      Spiro Taleski

      • NAl's avatar
        NAl
        Contributor
        5 years ago

        Thank you Spiro, found it