I created a power automate that is formatting date time to a number. I would expect one result but getting something different. Any thoughts on why this would be happening?
Here is my code
int(formatDateTime(input date, 'yyyymmdd'))
So if I input 4/5/2021, for some reason I am getting 20210005
If you notice my month section is not turning up 04 which would be expected to be there. Instead, I am getting 00 for a month.
Solved! Go to Solution.
Try this format instead
int(formatDateTime(input date, 'yyyyMMdd'))
'mm' in Power Automate pulls in the Minutes. 'MM' pulls in the Month.
Try this format instead
int(formatDateTime(input date, 'yyyyMMdd'))
'mm' in Power Automate pulls in the Minutes. 'MM' pulls in the Month.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
69 | |
27 | |
22 | |
15 | |
13 |
User | Count |
---|---|
132 | |
43 | |
42 | |
34 | |
31 |