date generator

[Anonymous]

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

[stevedark · Accepted solution]

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

[MarcoWedel]

maybe helpful:

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

regards

Marco