topic show updated QVD date and time in QlikView

show updated QVD date and time

Anonymous — Tue, 12 Jun 2012 16:42:37 GMT

Hi all,

I am interested in how to display the date and time of my QVD.

Once the date and time is displayed in the application, I am interested showing the QVD updated date and time

Ex: The QVD was created on 06/01/2012 at 13:00

The QVD was updated on 06/05/12 at 08:30

The date and time on my application should be 06/05/12 08:30.

Thanks in advance for your help.

Re: show updated QVD date and time

Anonymous — Tue, 12 Jun 2012 17:38:58 GMT

Hi,

Put this two functions in load .

load

now() as DateCreated,

filetime( ) as DateUpdated,

....

Re: show updated QVD date and time

Anonymous — Tue, 12 Jun 2012 18:00:08 GMT

ALLDATAV3:

LOAD Company,

Population

FROM

(ooxml, embedded labels, table is test)

The above is my load statement. I am wondering where in this load statement should in add the 2 functions you recommended? Thanks.

now() as DateCreated,

filetime( ) as DateUpdated,

Re: show updated QVD date and time

Anonymous — Tue, 12 Jun 2012 18:15:50 GMT

LOAD

now() as DateCreated,

filetime( ) as DateUpdated,

Company,

Population

FROM

...

Re: show updated QVD date and time

Jason_Michaelides — Tue, 12 Jun 2012 18:23:14 GMT

I think they're the wrong way round aren't they? Maybe:

LOAD

FileTime() as DateCreated,

Now( ) as DateUpdated,

Company,

Population

FROM

...

However! You may find that Now() slows down your load time considerably as it is evaluated every second. This also means that if your table takes longer than a second to load you will get differing values. Maybe use a variable at the end of the table load

Let vUpdate = Now();

Now() is only invoked once then. Or else look at the other qvd file functions in the reference manual - there are many of them!

Hope this helps,

Jason