Discussion Board for collaboration on QlikView Scripting.
I've a little problem, I load a table from a data base like this:
SQL SELECT *FROM fim.dbo."PIANO_DI_PRODUZIONE"order by ID_COMMESSA,DATA_ULT_RIC;STORE fim_PIANO_DI_PRODUZIONE
No problem it's work but it's a big table so i want to load only the lines where the creation date are higher than the last execution!
So I do :
Let ThisExecTime = ReloadTime(); PIANO_DI_PRODUZIONE:SQL SELECT *FROM fim.dbo."PIANO_DI_PRODUZIONE"WHERE DATA_ULT_RIC >= '$(ThisExecTime)';
But it doesn't work, no lines loading. I think it's a problem of data beetween ReloadTime and DATA_ULT_RIC.
DATA_ULT_RIC is in numeric like '38085,802407407' and the reloadtime '09/04/2013 05:45:12'.
How can I match this two date?
Thanks a lot for your Ideas/Answers!