Timezone with Drupal 9, CiviCRM entity and Views
Overview
We are working with grants, where fields like "money transferred" exist. This field is stored in the database as a "date-only" value (screenshot). However, Drupal interprets the date as a datetime field and, presumably, sets the time to 12 noon, but a day before. This leads to inconsistent dates in Drupal Views outputs. Is there a known workaround to avoid this issue? Currently, I have set a fixed 12-hour timezone difference for the View, which works but is not an ideal solution.
Reproduction steps
- Install civicrm entity and enable grants
- go to Drupal Views and create a new view based on grants.
- include fields like 'money transferred'
Current behaviour
Drupal interprets the date as a datetime field. Both attached screenshots are from the same entry.
Expected behaviour
Drupal interprets the date as a date field.
Environment information
D9.5, CiviCRM 5.62, civicrm_entity /latest