Would also like an update on this. The recommendation to create an additional date field we can manipulate is something we’ve done, however, it’s not really possible to then be able to query content based on that new date field (see this post).
So, for example, if we want to fetch content based on that new date field and sort by most recent based on that date field, there’s not really a good way to do that - especially if you have a lot of content and need to manage pagination, etc.