Hello,
I am trying to convert system date to in this format: mmddyyyy
So for today which is March 25th, 2021, it should show as 03252021
I am using the following formula:
Month(GetDate())+'/'+Day(GetDate())+'/'+Year(GetDate())
It worked but the results are coming up in format "3/245/2021". Is there a way, I can get the 2 digits for the month without having the "/". For instance. for today, the output should be: 0325202
Any ideas?
Thanks!