topic date generator in QlikView

date generator

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

good afternoon

I would like to help me'm trying to generate a date from the name of a QVD.

example my QVD is called F_MAYA_DETALLE_07102016.qvd there is a function for me to take the date on my qvd is 07,102,016

Thank you

regards

Luis Espinoza

Re: date generator

stevedark — Mon, 10 Oct 2016 22:27:13 GMT

Hi Luis,

There is a filename function. You should be able to do something like this in your load:

LOAD
Date(Date#(Left(Right(FileName(), 12), 8), 'DDMMYYYY'), 'DD MMM YYYY') as [File Date],

... load other fields here ...

There is a reasonably high chance that I have miscounted the characters in the suffix, but hopefully that should give you a good idea on how to get the date you require.

Steve

Re: date generator

MarcoWedel — Tue, 11 Oct 2016 22:53:03 GMT

maybe helpful:

Date(Date#(Subfield(FileBaseName(),'_',-1),'DDMMYYYY')) as YourQVDDate

regards

Marco