Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
maybe helpful:
Date(Date#(Subfield(FileBaseName(),'_',-1),'DDMMYYYY')) as YourQVDDate
regards
Marco