LT(x) and GT(x) macros not working on Multitenant

mohamed-ghozzi

Hi all,

We are unable to use macros LT(0) and GT(0) with relative dates on M3 programs (date format in MNS150 is DDMMYY) : 

OIS300 (OOHEAD indexed):

RLDT:GT(-150)  => not accepted

RLDT:GT(20250101) => accepted

RLDT:GT(250101) => not accepted

RLDT:GT(010125) => accepted

RLDT:GT(01012025) => accepted

RLDT:>DAY(-30) => not accepted

RLDT:>DATE(-30) => not accepted

RLDT:>DAY(0) and RLDT:>DATE(0) => not accepted

If format is set to YYYYMMDD in MNS150 : RLDT:>DAY(0) and RLDT:>DATE(0) are accepted but still not RLDT:GT(0)

QMS200 (table QMSTST indexed):

QTE1:GT(0) or STDT:GT(-118)  => not accepted

QTE1:GT(20250101)  => accepted

QTE1:GT(01012025)  => not accepted

Anyone got an idea about this?

Thank you in advance

Kind regards