Announcements
Hi
Please check my screenshots below.
I am trying to convert a selected datetime to yyyymmdd but the mm part comes out as 00.
Any assistance will be appreciated.
Thanks, Mark.
I experimented a bit and found that by capitalising the MM it works.
So, yyyyMMdd works but not yyyymmdd.
Seems a bit weird though 🤔
@Anonymous You probably are right about the "MM" part as it denotes Month. Just to let you know "mm" stands for Minutes and maybe the reason why you are getting 00 is since it is a date variable so dates without any time have the default timestamp of 00:00:00
For more reference over possible date time formats you can refer to this MSDN Doc For Date Time Formats
Ahh! Thanks for the info @AutomateWithDev much appreciated 🙂
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 594
Valantis 328
David_MA 281 Super User 2026 Season 1
