topic Re: If statement in script to compare QVD save date in QlikView

If statement in script to compare QVD save date

CNH_1978 — Wed, 25 Nov 2020 16:16:04 GMT

Hi, Can anyone tell me what is wrong with this script please?

let vQVDPath = 'C:\Users\User1\Desktop\';
let vToday = date(today(),'DD/MM/YYYY');

let vQVD_Date = date(QvdCreateTime('$(vQVDPath)TestQVD.QVD'),'DD/MM/YYYY') ; \\ only added to confirm date

if date(QvdCreateTime('$(vQVDPath)TestQVD.QVD'),'DD/MM/YYYY') = $(vToday) then

SET vResult = Yes;

ELSE

SET vResult = No;

ENDIF;

I am trying to compare todays date with the save time of the QVD, if the date matches then output YES otherwise output NO.

It seems to output NO even though the dates match (as seen below..

Many thanks in advance

fosuzuki — Thu, 06 Aug 2020 18:08:24 GMT

Hi,

Try changing your if to:

if date(QvdCreateTime('$(vQVDPath)TestQVD.QVD'),'DD/MM/YYYY') = '$(vToday)' then

(put single quotes on vToday)

CNH_1978 — Thu, 06 Aug 2020 18:36:04 GMT

Hi, thanks for your reply.

Unfortunately, single quotes didn't fix it either.

I have attached the QVW i am using.

hopkinsc — Thu, 06 Aug 2020 18:44:42 GMT

Hey,

I think the QvdCreateTime() function will return a timestamp, so try and wrap it in the left() function..

if left(date(QvdCreateTime('$(vQVDPath)TestQVD.QVD'),'DD/MM/YYYY'),10) = '$(vToday)' then

I think that should work.

Cheers

CNH_1978 — Thu, 06 Aug 2020 18:46:35 GMT

Fantastic, that is working.

Thanks!