floor reload time() issue

[#1]

Dear frnds,

we've an application running in our organzation which consists of two files

1) to create daily qvd : this file concatenates the data daily from an sql table to the qvd built a day before.

While taking the data from table the developer has used floor(Reloadtime()) as Rundate which shud take the numeric part of the day the

application is run and we shud see this date as the maximum date every day in the main application which runs on successful completion of this file.

2) Main application : But the issue for me is instead of showing this maximum date stored in the qvd, the application shows the date of a day before as the maximum date when date(Rundate) is used in the application.

For eg. if the Qvd is created on 12/07/2012 the main application shows 11/07/2012 as the maximum date.

nowhere is he using num(RUNDATE)-1.

And moreover this is what is exactly intended in the application so its not something that needs to be changed, but why is this happening ?

Regards

[swuehl]

Please check the referenced thread. The ReloadTime() returned in your script run and then used in the UI will differ, as

ReloadTime( )

Returns a timestamp for when the script last finished reexecuting.

During your script run, it will return the timestamp of the your last finished script run (i.e. the previous date if you run only once a day).

As soon as the script has finished, the just updated reloadtime timestamp will be displayed in the UI.

QT won't call this a bug, it is working as described.

[#3]

Hello Sir,

i've read Rob's explanation in the thread & now i understand the reason.

Thanks for the link

Regards