This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

Convert Date

Posted on 05-05-2021 06:29 AM
Cyril_M
New Member
Reply posted on --/--/---- --:-- AM

Hi,

I need to convert number / text : “210506” (21=year 05=month 06=day) to format Date as dd/mm/yyyy
how can i do that ?
Thanks all

Solved Solved
0 2 242
Topic Labels
Jump to Solution
0 Likes
Reply
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Steve
Platinum 5
Platinum 5
Reply posted on --/--/---- --:-- AM

This?

CONCATENATE(
  RIGHT([Text], 2),
  "/",
  MID([Text], 3, 2),
  "/",
  ("20" & LEFT([Text], 2))
)

See also:

View solution in original post

Jump to Solution
Reply
2 REPLIES 2
Top Labels in this Space