Hello, I am trying to convert system date to in this format: mmddyyyySo
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!