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

[BillZrv]

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!