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'))]"
Create an account today to enjoy exclusive features and engage with our awesome community!
Prijavi| Related Posts | Odgovori | Prikazi | Aktivnost | |
|---|---|---|---|---|
|
|
2
mar. 25
|
7779 | ||
|
0
dec. 24
|
2861 | |||
|
2
jan. 24
|
3251 | |||
|
Dynamic date in filters
Solved
|
4
apr. 25
|
14651 | ||
|
0
apr. 26
|
3553 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.