Days manipulation in Mappers

[eric_sou]

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,

[petar_rajchinos]

Hi eric.sou,

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

Expression Library: Start and end dates of previous month Expressions and Expression Libraries

The following expression library can be used to generate the start date and end date of the previous month in several formats. { // Convert the given Date-with-time object into a Date with only the year and month to_month_date: x => Date.UTC(x.getFullYear(), x.getMonth() - 1), // Get the start of the previous month based on the given date or the current time if no parameters are given prev_month_start: x => this.to_month_date((x || Date.now()).minusMonths(1)), // Get the e…

Let us know if you need further assistance 🙂

Regards,
Petar

[eric_sou]

Thanks petar. I will look into it.

[eric_sou]

Perfect, and easy to use. Thanks!