Last ReloadTime()

[Anonymous]

I have a RecordCreatedDate column in which record date along with time is stored.

How can I use the ReloadTime() in script so that I can load the data (RecordCreatedDate) which is greater than than previous ReloadTime.

Also, is there any temporary storage to store any value, such as ReloadTime() so that in can be used in next reload.

[MK9885]

Maybe the below script?

Refreshtime:

load

QvdCreateTime('C:\YOURDESTINATIONFORQVD\ABC.QVD') AS QVDTIME

AutoGenerate 1;

Load

Date(QVDTIME, 'MM/DD/YYYY hh:mm:ff TT') as QVDDate

Resident Refreshtime;

There can be more to it depending what you want....but this will only tell when the QVD was created

[ravikumar_iyana]

Hi Amar,

You can use like this  "   =' Last Refreshed Date: '&Date(ModifiedDate, requireddateformat)     "

[vishsaggi]

May be use a variable to store your refresh time like

LET vReloadTime = ReloadTime();

OR

LET vReloadTime = Date(ReloadTime());