Hi Chris,
The issue is that DateTimeValue returns the date using the current timezone of the machine where the app is being run. You need to use the datetime fromstring method to get the datetime in the timezone that relates to the stored value, you can then convert that value to the users timezone.
I’ve just posted a couple of extension methods I use for this purpose at https://forum.xojo.com/t/database-datetimevalue-extensions/68880
HTH
Wayne