Convert File Name (-01.22.22) to a date in QlikScript

[ahilgeman]

I need to extract the filename (TEST1 Update morning-02.08.2022) to '02/08/2022' in the script. How do I do that? So far I have this: (right(FileName(),10)) but it returns 02.08.2022, not a date. 

[maxgro]

try with

= DATE(DATE#(RIGHT('TEST1 Update morning-02.08.2022', 10), 'DD.MM.YYYY'))

Some help on interpretation and formatting of date fields

https://community.qlik.com/t5/QlikView-Documents/Primer-for-QlikView-Date-fields/ta-p/1478024?attach...