I have a number of date fields in a module (type: Date, not DateTime). I imported dates into quite a few when I populated the initial configuration and they all show up correctly in the detail, edit, and list layouts. However, I have included a few of them in a report and they all show up offset by one day in the report (one day earlier, e.g. 07/22/2019 shows up in the report as 07/21/2019. When I look directly in the MySQL tables, the dates match what I want them to be. I suspect that this may be an issue with time zones, but php has the timezone set to America/New_York and that’s also the time zone set on my profile (and for all other users). Is there some other setting somewhere that’s shifting dates enough to make them show the preceding date in all cases in reports? Or some other issue?
SuiteCRM Version 7.11.5
PHP 7.2.23