find created time of qvd

[ioannagr]

Hello all, I want to achieve incremental load on a huge table just to load new entries.

Now this table has indeed a date field in it, but peeking the max date is one coming from the future ( 2036 😂) so when i'm calling data from the db it throws an error, because  "where id>'$(MaxID)'  and datetime>'$(MaxDate)' ;" can't be, since today is 31/5/2021.

 I was thinking to find the last created date of the qvd and then  call from the database

"where id>'$(MaxID)'  and datetime>'$(LastCreatedDate)'; " so as to lower the loading time. 

How do I do it? What would you do?

[NitinK7 · Accepted solution]

you can try below in a script /backend.

let v_CreateTime = QvdCreateTime('QVD file path');