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,

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 :slight_smile:

Regards,
Petar

3 Likes

Thanks petar. I will look into it.

Perfect, and easy to use. Thanks!

1 Like