Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is there any way to get the QVW last modification date in script

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

1 Solution

Accepted Solutions
Not applicable
Author

Hi Bertrand,

what about

Let vMod = FileTime('RainersDaysBetween.qvw');

Result: vMod = 06.08.2009 10:17:42

One step forward now?

Rainer

View solution in original post

7 Replies
Not applicable
Author

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

Anonymous
Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

Hi Bertrand,

what about

Let vMod = FileTime('RainersDaysBetween.qvw');

Result: vMod = 06.08.2009 10:17:42

One step forward now?

Rainer

Not applicable
Author

Thanks !

that is what I was looking for.

I wouldn't seems to be needy but do you know an equivalent for creation date 🙂 ?

guytzumer
Partner - Contributor III
Partner - Contributor III

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);

Not applicable
Author

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