Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Convert System Date to mmddyyyy format

Avatar

Avatar
Validate 1
Level 2
alik98709228
Level 2

Likes

3 likes

Total Posts

26 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
alik98709228
Level 2

Likes

3 likes

Total Posts

26 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
alik98709228
Level 2

25-03-2021

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!
View Entire Topic

Avatar

Avatar
Validate 1
MVP
DavidKangni
MVP

Likes

246 likes

Total Posts

351 posts

Correct Reply

141 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Validate 1
MVP
DavidKangni
MVP

Likes

246 likes

Total Posts

351 posts

Correct Reply

141 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
DavidKangni
MVP

26-03-2021

Hi @alik98709228 

 

Please use this 

Iif(Month(GetDate())>9, ToString(Month(GetDate())), '0'+ToString(Month(GetDate())))+Iif(Day(GetDate())>9, ToString(Day(GetDate())), '0'+ToString(Day(GetDate())))+ToString(Year(GetDate()))

 

Also make sure to post in ACS forum instead of ACC.

 

Thanks,

David