Solved
Dynamic range of dates for REST
My current pipeline works with pipeline parameters defining the range of dates However my goal is to automatize this for each month. My idea is to schedule a task for the first of every month ...
Forum Discussion
rpc1235x - I created an set of expression libraries a while back that I think will resolve this for you. Rather than try to calculate this in a pipeline parameter which really only allows for static strings, I suggest you use the date.expr expression library and calculate the start and end dates in a Mapper snap as in the following screenshot.
You could choose to not use the expression library reference and perform the date truncation in the Mapper itself, but the "trunc" method simplifies the statement in your Mapper (and I like simple). 😉
I hope this helps!
Thank you for the response.
I have imported the expression library files to the Project Manager section. However, I have this error in the mapper connected to the REST Get. Is there an additional step to enable the expression library?
