Criteria based on current DATE/TIME - Eventhub alerts

Hi all,

Is it possible to set a criteria based on current date/time ? Is there a system variable corresponding to current date/time ?

For example : sending an alert if "DWDT" (requested delivery date) from table MPHEAD (PO headers) is less than [current date/time].

Regards.

Find more posts tagged with

Accepted answers

All comments

Jonathan Amiran

Hi,

I don't know if there is a special system variable for current date, but you can compare DWDT with LMDT which is always the current date for the event.

Jonathan.

fredericlebars

Hi,

OP version or Cloud Edition ?

On OP, drool rules are java code you can use java System.currentTimeMillis() to get system date-time.

On CE, I was'nt abble to do that kind of test. Maybe you can delegate it to iondesk/monitor conditions

BR Fred

Legacy Contributor

Good morning Jonathan, thank you for your help.

In MPHEAD table, LMDT stores the last change date. Which is; most of the time; different from current date if the PO header has not been updated. Are you meaning an LMDT field in another table ?

Legacy Contributor

Good morning Fred, thank you for your help. We are using M3 OP. I will check this.

fredericlebars

Hi,

This is an example of datas received in eventanalytics from m3 (to see theses datas use eventhub vizualization)

In drool rule code you should be able to use servertime or client time received from the event.

Regards Fred

Copyright © 2025 Infor. All rights reserved.