Skip to Content
Menu
This question has been flagged
1 Reply
2796 Views

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
Discard
Best Answer

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
Discard
Author

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.

Author

I configure this way too . but results was same .

Related Posts Replies Views Activity
1
Jun 20
2055
0
Jun 20
1696
1
Mar 21
2520
0
Jan 21
1322
0
Jun 20
1944