how to convert left(filename,6) to date field

[ashmitp869]

Hi,

How to covert this to date -

This is the filename taking only left(filename,6), I need to covert it to date i.e 15 March 2022.

[MarcoWedel · Accepted solution]

Date#(left(filename,6),'DDMMYY')