Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

the last date of loading data

hi all,

can anyone please tell me how to get  date of the last loading of values from database (the last update)

2 Replies
MVP
MVP

Re: the last date of loading data

if you mean the time of QlikView load you can use the function

ReloadTime( )

Returns a timestamp for when the script last finished reexecuting.

if you mean the last time a record in a db table was updated/inserted, you need an ad hoc field in the db table

EDIT:

In script, ReloadTime() returns the end time of the previous reload

For start time of the script you can use a variable at the beginning of the script

LET startofthescript = now(1);          // 1 Time at function call

Re: the last date of loading data

Create a variable at the end of your script:

vLastReload = Now();

now the next time you reload, vLastReload will be the timestamp of when your last reload finished.

Community Browser