pipeline expression - previous month

Question

hello,
This is what I am using inside the copy activity pipeline where I pass in the daysBack, i.e. -5 and then it build the string with dates from 5 days ago:

@markus.bohland@hotmail.de (
dataset().dateFieldName, ' > ', formatDateTime(addDays(dataset().currentDate, int(dataset().daysBack)), 'yyyy-MM-dd'),
' and ', dataset().dateFieldName, ' < ', formatDateTime(dataset().currentDate, 'yyyy-MM-dd')
)
This works fine but now this is what I would like to do where the above expression gives back data for the previous month when-ever I run it.
for example, something like this perhaps?
@markus.bohland@hotmail.de (
dataset().dateFieldName, ' > ', firstDayOfPreviousMonth - 1,
' and ', dataset().dateFieldName, ' < ', LastDayOfPreviousMonth + 1
)

Thank you

Answer 1

Hi @arkiboys ,

you can get Days with the following expressions:

'2022-01-31' (last day of the month before previous month) --> addDays(formatDateTime(subtractFromTime('2022-03-20', 1, 'MONTH'),'yyyy-MM-01'), -1, 'yyyy-MM-dd')
and '2022-02-01' (first day of previous month) --> formatDateTime(subtractFromTime('2022-03-20', 1, 'MONTH'),'yyyy-MM-01')

Thanks!