Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am trying to extract Date from a filename in excel
Sample file name: '2018-01-07 text1 text2 text3'
I am trying to convert this date from the above format to a MM/DD/YYYY format as well.
Could someone please help me with that?
Try something like this
Date( Date#(Subfield(FileBaseName(), ' ', 1),'YYYY-MM-DD'), 'MM/DD/YYYY') as FileDate
From '2018-01-07 text1 text2 text3' ;
I am using trace in a loop for a bunch of files. I tried your method but it is not able to load.