topic Re: how to extract date from filename in QlikView

how to extract date from filename

Mon, 26 Jan 2026 18:19:17 GMT

i have a doubt can you clarify me i have a data in which i have to retrieve date from excel name i have done using

left(right(filenmae)2)1)

but i have doubt if have date in 29-jan-2016 how can i get date without using left and right function how ever the data may be i should get it dynamicly

Re: how to extract date from filename

MK_QSL — Wed, 08 Jun 2016 12:03:30 GMT

What is the filename?

Re: how to extract date from filename

Wed, 08 Jun 2016 12:04:56 GMT

MAC_R2_CR_PBTV_ACCOUNTS_04-july-2016

Re: how to extract date from filename

MK_QSL — Wed, 08 Jun 2016 12:07:57 GMT

LOAD

Date(Date#(SubField(FileBaseName(),'_',-1),'DD-MMM-YYYY')) as Date

FROM

YourFile

LOAD

Date(Date#(SubField(FileBaseName(),'_',-1),'DD-MMMM-YYYY')) as Date

FROM

YourFile

Re: how to extract date from filename

Wed, 08 Jun 2016 12:19:45 GMT

thanks Manish i have doubt i want to retrieve date dynamically what ever the format the date is like

MAC_R2_CR_PBTV_ACCOUNTS_04-july-2016

MAC_R2_CR_PBTV_ACCOUNTS_04-07-2016

Re: how to extract date from filename

MK_QSL — Wed, 08 Jun 2016 12:24:04 GMT

LOAD

Date(Alt(

Date#(SubField(FileBaseName(),'_',-1),'DD-MMM-YYYY'),

Date#(SubField(FileBaseName(),'_',-1),'DD-MMMM-YYYY'),

Date#(SubField(FileBaseName(),'_',-1),'DD-MM-YYYY')

)) as Date

FROM

[MAC_R2_CR_PBTV_ACCOUNTS_*.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: how to extract date from filename

Wed, 08 Jun 2016 12:28:28 GMT

no Manish i am asking the file name may be either like this

MAC_R2_CR_PBTV_ACCOUNTS_04-july-2016

MAC_R2_CR_PBTV_ACCOUNTS_04-07-2016

however it is it should work in a single expression

Re: how to extract date from filename

MK_QSL — Wed, 08 Jun 2016 12:31:25 GMT

Use this.... to extract date field... it should work..

Date(Alt(

Date#(SubField(FileBaseName(),'_',-1),'DD-MMM-YYYY'),

Date#(SubField(FileBaseName(),'_',-1),'DD-MMMM-YYYY'),

Date#(SubField(FileBaseName(),'_',-1),'DD-MM-YYYY')

)) as Date

Re: how to extract date from filename

Wed, 08 Jun 2016 12:36:07 GMT

great manish tanks for your help

Re: how to extract date from filename

MK_QSL — Wed, 08 Jun 2016 12:37:11 GMT

If you have got the correct solution, kindly close the thread by selecting correct answer.. this will help others having same issue.