Forum Discussion

eric_sou's avatar
eric_sou
New Contributor III
7 years ago

Days manipulation in Mappers

Hi all,
I am facing now an issue manipulating the Dates in expressions.
I am trying to generate, within a mapper:

  • Get the date of first day of previous month (eg: for now : 01/11/2019)
  • Get the date of last day of the previous month (eg: for now: 30/11/2019).

Though, I know how to do this simply in my Oracle Query, I would prefer to get those info within a mapper at the run time of the pipeline.
Thanks,

3 Replies

  • petar_rajchinos's avatar
    petar_rajchinos
    New Contributor III
    7 years ago

    Hi eric.sou,

    Please check the following link, it is a post from @dmiller. I hope it will help you.

    Let us know if you need further assistance 🙂

    Regards,
    Petar

    • eric_sou's avatar
      eric_sou
      New Contributor III
      7 years ago

      Thanks petar. I will look into it.