Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odpovědět
3646 Zobrazení

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
Zrušit
Nejlepší odpověď

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
Zrušit
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 .

Related Posts Odpovědi Zobrazení Aktivita
1
čvn 20
2756
0
čvn 20
2519
1
bře 21
3250
0
led 21
2030
0
čvn 20
2898