Convert Date

[Cyril_M]

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

[Steve · Accepted solution]

This?

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

See also:

help.appsheet.com

CONCATENATE()

Merged text from parts

help.appsheet.com

LEFT()

Left-most characters of text

help.appsheet.com

MID()

Characters from text

help.appsheet.com

RIGHT()

Rightmost characters of text

[Cyril_M]

Thanks