Q: I exported a report out of Ventures into Excel but the Date and Time don't match up with what I see in Ventures. How can I fix the date?

Like many modern databases, Ventures stores and time stamps actions using the Coordinated Universal Time (UTC) standard. These dates are stored in the database and are converted into your local time based on your account settings. Sometimes, when you request data into Excel either in the Reports area or from a grid in Ventures, the data is exported exactly as it is in the database. So in order to change the date to Local Time, you will need to add an additional column and perform a quick calculation.

1. First, you need to find your Local Time offset versus UTC time. You can do a quick search on the Internet to find the current offset. Please be aware that UTC does not account for Daylight Savings so the offset hours will change depending on DST.
2. Once you know your offset, you will need to add a formula into Excel. The Formula you will use will be:
   = (Reference Column) +/- (Offset Hours / 24)
3. Click and drag this formula to copy it into the rest of the column.

EXAMPLE: I exported the loan creation date from a grid in Ventures but the date doesn't match up to what I see in Ventures. I looked up the current offset hours for the Pacific Daylight timezone and found that it is -7. So the formula I need to use to convert to Local Time is: =(Reference Column) - (7/24).