Update/change status of an enum field based on date field

[lahore]

Hello espocrm community,

I need some help!

I would like to have changed the status of an enum field automatically when a pre-set date field in future has less than 14 days to come.
Formula ?

How can it trigger automatically ? Through cron ?

Thanks in advance...
lahori

[tanya]

It's easy to do this with Workflow without developing. https://www.espocrm.com/video/workfl...n-in-business/
Or you could develop a job https://www.espocrm.com/documentatio...scheduled-job/ https://www.espocrm.com/documentation/development/orm/