How to change status based on expiry date

[ivan2805]

Hi All

I need some help.
I've created a new entity called session, in that entity I have 2 fields, they are status (Enum) and expiry date (Date).

For default I've set the status to "Active", however I need to change the status automatically into "Expired" when the expired date hits greater than today.

Is there any way to achieve this using formula since i don't have the advance pack.

Thank you in advance for your help

[shalmaxb]

This is easy to achieve by formula datetime

ifThen(
datetime\date(expiryDate) > datetime\today(),
entity\setAttribute(status, 'Expired')
);

Advance Pack not necessary.

[ivan2805]

hi Shalmaxb,

Thank you for tthe reply, If im not mistaken this will be done after the save right?
In order to do it automatically (Without save) what should i do?

[shalmaxb]

unfortunately I cannot help with that, but I think it is not possible.

[rabii]

you can use a job and schedule the job on specific time, it will be executed in the background without need to save.

[esforim]

At the end of the day, must have it else not possible. Not unless you can create a CRON job to refresh it on a time basis.