Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
advaitmodak
New Contributor

Date from file name and format.

Hi, 

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? 

Thanks! 

 

2 Replies
Partner
Partner

Re: Date from file name and format.

Try something like this

First 1

Load

Date( Date#(Subfield(FileBaseName(), ' ', 1),'YYYY-MM-DD'), 'MM/DD/YYYY') as FileDate

From '2018-01-07 text1 text2 text3' ;

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
advaitmodak
New Contributor

Re: Date from file name and format.

I am using trace in a loop for a bunch of files. I tried your method but it is not able to load.