Menu
SuiteCRM dedicated support by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: AOR Reports 'Today' Variable Not Considering TZ DB using UTC.

AOR Reports 'Today' Variable Not Considering TZ DB using UTC. 4 months 2 weeks ago #68536

  • ocean
  • ocean's Avatar
  • Offline
  • New Member
  • Posts: 10
  • Thank you received: 2
  • Karma: 1
After looking at AOR_report.php, i can see that curdate() is used to create the query to fetch the results for TODAY. The final query is not allowing for entries that are UTC timestamp in the DB into the next day.

ie.... 06/28/2018 curdate() fetches records with that date. We create records in the -4UTC timezone until 21:00 HOURS which records entries at 06/29/2018 00:59

it appears that Suitecrm is not designed to display reports correctly when entering records later in the day .

Anyone know of a workaround or fix. This is driving me crazy not seeing the last two hours of records for the day on our reports. Not to mention seeing the prior days late records on the current days reports. it's a simple TZ shift but seems impossible to fix.
The administrator has disabled public write access.

AOR Reports 'Today' Variable Not Considering TZ DB using UTC. 4 months 3 days ago #69172

  • Dillon-Brown
  • Dillon-Brown's Avatar
  • Offline
  • Administrator
  • Posts: 177
  • Thank you received: 53
  • Karma: 12
Hi ocean,

Would you be able to raise this as a bug on Github? github.com/salesagility/SuiteCRM/issues/new

Thanks.
The administrator has disabled public write access.

AOR Reports 'Today' Variable Not Considering TZ DB using UTC. 4 months 2 days ago #69195

  • ocean
  • ocean's Avatar
  • Offline
  • New Member
  • Posts: 10
  • Thank you received: 2
  • Karma: 1
Sure, my programming team has also implemented a good fix for this as well. I will post everything to github when i get some free time.
The administrator has disabled public write access.
The following user(s) said Thank You: pgr
Time to create page: 0.055 seconds
Powered by Kunena Forum