Combine Date + Time from qvd and compare to SQL with different format

BillZrv — Mon, 26 Jan 2026 18:19:17 GMT

Hello everyone,

I need to find the row with the latest date and time from a qvd file and compare it with a table in SQL.

The problem is that Date and Time, in both cases (qvd & sql) are in two separate columns,

plus, in different formats.

I also experienced some trouble trying to find the max date from qvd and then covert it back to a date format.

the dates in the qvds are stored like this:

NUM([ActionResultDate]) AS ActionResultDate_KEY
TIME([ActionResultTime],'hh:mm:ss') AS ActionResultTime

while in SQL like this:

[ActionResultDate] = date (example 2022-04-04)

[ActionResultTime] = varchar(10) (example 15:03:26)

General specifications of the qvw is:

general qvd file format ->

date: 'DD/MM/YYYY',

time: 'h:mm:ss TT' ,

TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT'

I need to bring the latest date and time from the qvd in order to push in into a where clause while loading other data from an sql table.

What I need the dates & time for:

Table:

Load a,b,c

select a,b,c

from SQLtable

where ([ActionResultDate] + [ActionResultTime]) > $(LastUpdatedDate&Time from the qvd file)

thank you so much for your time!

topic Combine Date + Time from qvd and compare to SQL with different format in QlikView