İçereği Atla
Menü
Bu soru işaretlendi
1 Cevapla
4077 Görünümler

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

Avatar
Vazgeç
En İyi Yanıt

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.


Avatar
Vazgeç
Üretici

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.

Üretici

I configure this way too . but results was same .

İlgili Gönderiler Cevaplar Görünümler Aktivite
1
Haz 20
3228
0
Haz 20
3064
1
Mar 21
3779
0
Oca 21
2506
0
Haz 20
3349