How to update a field in Parent (Organisation) based on custom date field in related Child (opportunity) overnight job

May 19, 2016 at 7:31 AM
Hi,
Sorry I'm a bit new to this CRM development world, I need to update a field in the Organisation entity based on custom date fields in related (child) entity.

I was trying to use Rollup field but cannot use if StartDate <= Now()
It only like to add fixed values or fields. I then tried to add a computed date field in the child entity and set it to now() but Rollup filed does not like it too

The field needs to be updated overnight for all records if they meet the criteria.
any other options anyone can suggest.