Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
For my development, I need to get the last modification date in the script in order to use it in calculation.
Is there any way to get this ?
Regards
Hi Bertrand,
what about
Let vMod = FileTime('RainersDaysBetween.qvw');
Result: vMod = 06.08.2009 10:17:42
One step forward now?
Rainer
Hello,
At the end of the script you can create one variable as Last_modified and keep the date in that.
This way you can have the last modified date next time u run the application
Talha
If the question is about the last relaod time, there is no need to create anything in the script. There is QV function ReloadTime() that returns the timestamp of the last reload. You can format the result in any way you want.
Thanks for your answer :
In fact I'm not tryning to find the reloadtime but the modification date of the file (I now it is often the same thing but not in that case 🙂
Thanks anyway
Hi Bertrand,
what about
Let vMod = FileTime('RainersDaysBetween.qvw');
Result: vMod = 06.08.2009 10:17:42
One step forward now?
Rainer
Thanks !
that is what I was looking for.
I wouldn't seems to be needy but do you know an equivalent for creation date 🙂 ?
I'm usually use the file time of one of the qvd's i'm using.
that way you know for sure what date the DATA related to !
like this:
Date_Update:
LOAD Distinct
filetime( ) as DateUpdateTime;
FROM xxxxxxx (qvd);
Bertrand,
if you have a look in QlikView help file searching for "File functions" you will find QvdCreateTime() as function for this.
Maybe a workaround.
Rainer