Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Put this two functions in load .
load
now() as DateCreated,
filetime( ) as DateUpdated,
....
LOAD
now() as DateCreated,
filetime( ) as DateUpdated,
Company,
Population
FROM
...
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