Calculating a Date

(0) Share

Report

Posted on by robgar

133

Hello-

I need to find the 1st day of the month 60 days after a particular date. For instance, if the inputted date was 4/5/2020 + 60 days, I would be looking for 7/1/2020. I know how to do in excel: =EOMONTH(A1,2)+1.

Any ideas how to accomplish as an formula expression in power automate and place in a variable? I figure I would use the addDays function like below to add 60 days, but then I don't know how to find the 1st day of the next month. Do I have to set 2 variables (1) for date + 90, then (2) take the new date variable and use startofMonth expression to get 1st day of that month? Seems convoluted to do it that way. Thoughts?

addDays(variables('varStartDate'),60)

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

ganeshsanap 1,555 on at

Like (0)

Report
Copy link

Link copied!
@robgar , you can use startOfMonth function to get the start (1st day) of the month for a timestamp.

startOfMonth('2018-03-15T13:30:30Z')

above formula returns this result: "2018-03-01T00:00:00.0000000Z"

startOfMonth('2018-03-15T13:30:30Z', 'yyyy-MM-dd')

And it returns this result: "2018-03-01"
Reference: Functions Reference - startOfMonth
Please click Accept as solution if my post helped you solve your issue. This will help others find the correct solution easily. It also closes the item. If the content was useful in other ways, please consider giving it 👍

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @robgar ,

You could refer to screenshot below to create the flow:

formatDateTime(addToTime(addDays(outputs('Compose'),60), 1, 'Month'),'yyyy-MM-01')

The flow would run successfully as below:

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No