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.
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.
View solution in original post
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.