Data Editor | Date comparison not working

TinaHensel — Mon, 13 Sep 2021 08:27:11 GMT

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

Re: Data Editor | Date comparison not working

tresB — Mon, 13 Sep 2021 09:17:17 GMT

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