topic Date from file name and format. in App Development

Date from file name and format.

advaitmodak — Sat, 16 Nov 2024 20:21:48 GMT

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!

Vegar — Mon, 29 Jul 2019 22:35:47 GMT

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' ;

advaitmodak — Tue, 30 Jul 2019 12:42:51 GMT

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