I need a filter that will filter production orders only with date_planned_start in the current week.
Can you please advise.
I need a filter that will filter production orders only with date_planned_start in the current week.
Can you please advise.
please try to use this filter command in your search view
<filter string="This Week" name="date_planned_start" domain="[ ('date_planned_start', '>=', (datetime.datetime.combine(context_today() + relativedelta(weeks=-1,days=1,weekday=0), datetime.time(0,0,0)).to_utc()).strftime('%Y-%m-%d %H:%M:%S')), ('date_planned_start', '<', (datetime.datetime.combine(context_today() + relativedelta(days=1,weekday=0), datetime.time(0,0,0)).to_utc()).strftime('%Y-%m-%d %H:%M:%S'))]"/>
domain="[('date_planned_start','>=',(context_today() relativedelta(days=context_today().weekday())).strftime('%Y-%m-%d')),('date_planned_start','<', (context_today()+relativedelta(days=7-context_today().weekday())).strftime('%Y-%m-%d'))]"
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
|
2
mar 25
|
7782 | ||
|
0
dic 24
|
2880 | |||
|
2
gen 24
|
3260 | |||
|
Dynamic date in filters
Risolto
|
4
apr 25
|
14667 | ||
|
0
apr 26
|
3560 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.