STRING TO DATE

[sal21]

i can have:
mystring="08012021"
...
mystring="11032022"

how to return:
mydate=8/01/2021
...
mydate=11/03/2023

note:
mystring as string
mydate as date

[HansV]

Code: Select all

mydate = DateSerial(Right(mystring, 4), Mid(mystring, 3, 2), Left(mystring, 2))

[sal21]

Code: Select all

mydate = DateSerial(Right(mystring, 4), Mid(mystring, 3, 2), Left(mystring, 2))

Tks.
Work