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!
