show updated QVD date and time

[Anonymous]

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.

[Anonymous]

Hi,

Put this two functions in load .

load

now() as DateCreated,

filetime( ) as DateUpdated,

....

[Anonymous]

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,

[Anonymous]

LOAD

now() as DateCreated,

filetime( ) as DateUpdated,

Company,

Population

FROM

...

[Jason_Michaelides]

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