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?
Solved! Go to 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,
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,
You are awesome thank you!
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
40 | |
36 | |
29 | |
28 | |
27 |