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
3642 Widoki

Hi,

I tried like this

1. domain="[('appointment_sdate', '<=', (context_today() + relativedelta(months=1)).strftime('%%Y-%%m-01 00:00:00')),('appointment_sdate','>=',time.strftime('%%Y-%%m-01'))]"/>


2.domain="[('appointment_sdate', '<=', (context_today() + relativedelta(months=1)).strftime('%%Y-%%m-01 +05:30:00')),('appointment_sdate','>=',time.strftime('%%Y-%%m-01'))]"
appointment_sdate is the datetime field.


3.domain="[('appointment_sdate','>=',context_today().strftime('%%Y-%%m-01')),('appointment_sdate','


appointment_sdate is the datetime field.

all methods are working shows current month values and additionally values of next month 1st day's from 12.00 AM to 5.30 AM.

is anyone knows how to avoid the this from filter.?

I am using the

date format :%d/%m/%Y

time format:%I:%M:%S %p

Awatar
Odrzuć
Najlepsza odpowiedź

Hi,

1. I hope the domain seems to be correct

2. As you say, if it brings exactly the 5:30 hrs data, then the problem is your timezone for that user who is filtering the data.

3. Settings -> Users -> Preferences -> Timezone.

This should be correctly mapped when you create a new user .

Hope it helps,

Thanks.


Awatar
Odrzuć
Autor

Thanks for replay.I checked. time zones are correct. i think UTC time zone is taken

that why Indian UTC +5.30 difference there.

i think filter choose from based on UTC time . May i know how to change to system time format

Hi,

I have already mentioned how to configure timezone for each users,

3. Settings -> Users -> Preferences -> Timezone.

Autor

I configure this way too . but results was same .

Powiązane posty Odpowiedzi Widoki Czynność
1
cze 20
2755
0
cze 20
2505
1
mar 21
3249
0
sty 21
2026
0
cze 20
2896