Excel export - export local DateTime values

🌎 Discussion in English
1

Good day,

I’m not sure if this has been answered previously. If so, I apologize.

I am using ToBrowserLocalTime() quite extensively in GridViews throughout my project, because I have users in several global locations.
All dates are stored as UTC in our database.

Is there a way to export the converted local times when exporting the grid data to Excel?

Thanks

2

I’m sorry, but I don’t think that is possible. The export is performed on the server, where the client timezone is unknown and therefore ToBrowserLocalTime just returns UTC to avoid throwing an exception.

If you know the timezone by other means, you can manually adjust the data in the view model before the export

3

I thought as much.
Thanks for your response. Have a great day.