I have a report that shows Dates. I am in the UK and time changes changes in March (adds 1 hour) till October.
So when I pull the report the time shows in BST British Summer time. but since this report needs to be imported into a different system, i need it to show in UTC.
I changed the settings to show GMT - but that does not change the report.
I need either a way to change the settings, or a formula to say something like If date between xx/March and xx/october then add subtract 1 hour. Is that possible?