How is that possible?

[NenadV]

Hi,

This can’t be simpler, but it doesn’t work as expected and  as it has been working for 11 years.

if(date(PL03006) > date(today()), 'N', 'Y') as P_OpenInv_Overdue,

For example, an Invoice with a due date of 2026-04-01 4 is shown as overdue, which, based on the above if statement it should not be the case.

FYI:

DueDate in ERP: PL03006 with this value in the DB: 2026-04-29 00:00:00.000

[marcus_sommer]

I would look on the real loaded values in QV. Means something like:

PL03006 as A
isnum(PL03006) as B
today() as C,
recno() as RecNo,
rowno() as RowNo,
...

and then using a table-box to look on these values. 

[NenadV]

Thank you @marcus_sommer 

Here it is:

A	B	RecNo	RowNo
01.04.2026 0:00:00	-1	1030	0
01.04.2026 0:00:00	-1	1031	0
01.04.2026 0:00:00	-1	1032	0
01.04.2026 0:00:00	-1	1033	0
01.04.2026 0:00:00	-1	1034	0
01.04.2026 0:00:00	-1	1035	0
01.04.2026 0:00:00	-1	1036	0
01.04.2026 0:00:00	-1	1037	0
01.04.2026 0:00:00	-1	1038	0
01.04.2026 0:00:00	-1	1039	0
01.04.2026 0:00:00	-1	1040	0
01.04.2026 0:00:00	-1	1041	0
01.04.2026 0:00:00	-1	1042	0
01.04.2026 0:00:00	-1	1043	0
01.04.2026 0:00:00	-1	1044	0
29.04.2026 0:00:00	-1	1045	0
29.04.2026 0:00:00	-1	1046	0
29.04.2026 0:00:00	-1	1047	0
29.04.2026 0:00:00	-1	1048	0
29.04.2026 0:00:00	-1	1049	0
29.04.2026 0:00:00	-1	1050	0
29.04.2026 0:00:00	-1	1051	0
29.04.2026 0:00:00	-1	1052	0
29.04.2026 0:00:00	-1	1053	0
29.04.2026 0:00:00	-1	1054	0

[NenadV]

DueDate in QlikView is  normal Date type of field so there should be no issues, whatsoever.

[NenadV]

DueDate in QlikView is  normal Date type of field so there should be no issues, whatsoever.

[marcus_sommer]

Are you looking on the same respectively the right field? Further the tags are only an indicator and no certainty that really all values have the proper pattern and the expected values. The incoming values might be wrong, empty or missing/null ...

Also there might be n different values in regard to the dimensionality and depending on how to look on them you may not see the entire truths. Therefore the above suggestion to look at first on the real existing values within a table-box.

[NenadV]

@marcus_sommer , here are the values:

[NenadV · Accepted solution]

This  if(date(PL03006) < date(today()), 'Y', 'N') as P_OpenInv_Overdue,

has started working ok as it hs been  workinig nice in the last 11 years . Case closed. Thanks @marcus_sommer  for your time and good will.

happy Easter.