AnsweredAssumed Answered

How can i automatically change the time zone in our Canvas Data extracts?

Question asked by Cathy Himmelmann on Mar 5, 2017
Latest reply on May 15, 2017 by Stuart Smith

I am working with our Canvas Data Portal extract files. Let me say that I am very new at this and have no coding background. I wish to eventually use the data with Access so that I can query, run reports, etc. We are in the Eastern Time Zone; however, all data from Canvas extracts are from Canvas's time zone. I know that I can take the data which extracts as all text into Excel and run the formula =cell-(5/24) and format the cells to make these changes. It just seems that there should be an easier way to do this. I mean you are talking about over 80 files that contain the wrong time zone. I have the data files downloading and unpacking every day. I just need help with this time zone issue. Any thoughts out there? Your input will be greatly appreciated. Thanks in advance.