Hello All,
I created Custom app and custom doctype. I am displaying appointment details for custom doctype on Calendar. But the time on calendar and in doctype is different and having difference of 2:30 hrs.
Can anyone help me to solve this???
Maybe you have a timezone issue!
In demo.erpnext.com the Event EV00001 posted in the Calendar differs by 2 hours.
And Newfoundland here in Canada is 1/2 hour ahead of the mainland or UTC minus 3 1/2 hours Newfoundland Time Zone - Wikipedia
A table here lists India as as UTC + 5:30 hours Time zone - Wikipedia
@clarkej I Written this query to display data in calendar is there any changes needed in following query
frappe.db.sql("""select c.name, c.docstatus as status, c.name as parent, CONCAT( c.doctor, "-",c.hospital, "-",c.surgeon) as doctor, addtime(c.appointment_date, c.appointment_time) as start_date, c.appointment_date as end_date from tabCase c, tabDoctor d where c.docstatus = 1 and c.doctor = d.name and (appointment_date between %(start)s and %(end)s)""".format(), { "start": start, "end": end }, as_dict=True, update={"allDay": 0},debug=1)
“In demo.erpnext.com the Event EV00001 posted in the Calendar differs by 2 hours.”
You don’t think best to resolve this first?
Yes I must research this but need a few days to dig into it - there is a fundamental learning to be had here!
@Bhagyashree_Aher my local instances do not have your time difference issue.
These ideas below may help solve your problem:
I have checked this issue.
Frappe is converting time to user time zone.
If system time zone if changes, then it will fix this issue.
Thank you kolate_sambhaji!
I have no clue how you ran your query or the context, please have you a pointer for the curious.
This turned up
frappe@erpnext:~/frappe-bench$ find . -name *.py | xargs grep 'def now_datetime'
./apps/frappe/frappe/utils/data.py:def now_datetime():
but nothing for this
frappe@erpnext:~/frappe-bench$ find . -name *.py | xargs grep 'convert_to_system_tz'
And in the ‘bench console’ this worked:
In [15]: frappe.utils.data.now_datetime()
Out[15]: datetime.datetime(2017, 4, 29, 13, 19, 40, 27328)
In [16]: import frappe.datetime
---------------------------------------------------------------------------
ImportError Traceback (most recent call last)
/home/frappe/frappe-bench/apps/frappe/frappe/commands/utils.pyc in <module>()
----> 1 import frappe.datetime
ImportError: No module named datetime
Possibly a sql stored procedure but I am not savvy…
Thanks!
You can run this command in browser console, as it is javascript.
you can find convert_to_system_tz is used in calendar js.
Reference for browser console:
2 Likes
Excellent - I overlooked js and now will learn how to run it in a console - thanks for these!
I have done some more research.
While creating events frappe is not converting user time to system time zone, but while showing it in Event Calendar its converting time to User Time Zone.
So, if users are in different timezone, then it adds some trouble.
1 Like