I am using Drupal 9 I have a custom entity which I am using to log some events. In my view, I wish to add a filter to retrieve entities created between two dates. My view displays the date as dd-mm-yyyy, which is what I need it to do. However, as the created date is a timestamp, my view returns each row, as each timestamp is different. My thinking is that I either need to coerce the the created date to a different format just before it is saved to the database, or to somehow get the query to process the timestamp just to the date level and ignore the time portion. I also need to do something similar in order to get an aggregate of entered values on a specific date or between two dates
Are either of those possible? If so, is anyone able to give me some guidance as to how to achieve it?
If I am thinking along the wrong lines, is anyone able to guide me as to what I should be doing?
Many thanks.
