Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
2384 Widoki

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.

Awatar
Odrzuć
Najlepsza odpowiedź

# Get today's date

today = datetime.date.today()

and to calculate the remaining days, you can loop through the projects and calculate it (try this I'm not sure)

remaining_days = (project.date - today).days

then Update the project status based on the condition

Awatar
Odrzuć
Autor

Thanks Sayed. This works!

Powiązane posty Odpowiedzi Widoki Czynność
1
gru 22
4665
2
paź 24
1211
2
gru 20
5251
3
cze 25
838
1
lip 25
1175