subtract month from now

arkiboys 9,686 Reputation points

In data factory dynamic content I am building a string as follows
but it appears there is no function for addMonth.
I would like to takeaway month from current date.
How can I do this please?

'myTimestamp gt ', addMonth(utcNow(), -1),
' and myTimestamp lt ', addDays(utcNow(), -1),

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,899 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 29,996 Reputation points MVP

    please use the below expression: