Hello, I'm using Odoo 17.2 online (so no direct access to code).

I'm creating a Scheduled Action for status updates on projects: 

every run, the automation should check all the projects that are not in cancelled or done statuses and update their realted project.update field base on 2 conditions:

1. if the "remaining days" are 0 or 1 -> Set the project state update state to "At Risk" 
2. if the "remaining days" are Set the project state update state to "Off Track" 

Where remaining days = Project.date - today() in days

My Dilemma: 

I can't calculate the "Remaing Days" value. I've already tried several python constructs but they gives me always errors. Is there an explanation document on how to use datetime date interval functions inside Odoo online (or Odoo Studio let's say) ?

Thanks in advance for the help

LucaB.