Day 15 of Last month

[senen]

Hi there, 

I need to run a flow on the first of every month. 

It runs a stored procedure that grabs data from day fifteen of the previous month to the End of the Previous Month

End of Previous month seems to be : addDays(startofmonth(utcnow()),-1)

Can you help me figure out how can I get the day fifteen of previous month? 

[v-bacao-msft · Accepted solution]

Hi @senen ,

You can get the day fifteen of previous month based on the method you provided for the End of the Previous Month.

Please try this expression:

addDays(startOfMonth(addDays(startOfMonth(utcNow()),-1)),14)

Or you need a time format like 'yyyy-MM-dd':

addDays(startOfMonth(addDays(startOfMonth(utcNow()),-1)),14,'yyyy-MM-dd')

Hope it helps.

Best Regards,

[senen]

You are awesome thank you!