Data Editor | Date comparison not working

[TinaHensel]

Hello all,

I am currently dealing with the following problem: I have a .qvd file from which I extract the maximum date:

LOAD max(%ID_ZEIT_TAG_SK) AS maxday
FROM [$(v_QVD_Path)/daten.qvd](qvd);

The result is 44452. But when comparing this value with the current date in the data editor, the following query is not working:

IF num(maxday) = num(today()) then

trace LOAD!;

end if;

But if I compare these two values inside a table, it is working:

Does anyone have a solution?

Thank you!

Best regards

Tina

[tresesco · Accepted solution]

Your mxday is a field here and you have to get the value from this field into a variable and then it should work as expected. Try like:

Load Max(....  as maxday...;

Let vMaxDay=Num(Peek('maxday'));

IF $(vMaxDay) = num(today()) then