Data export - times in UTC

Shaleesa
Shaleesa Posts: 2
edited July 22 in Sales CRM #1

Hello,

I'm exporting activity data in order to build timesheets for billing clients. What's frustrating is that even though the users have entered their activities in the local time zone, in the data export it's all in UTC time. I need the data to be in local time as different rates apply to day shift as opposed to night shift. Is there a way to fix this?

Thanks!

Comments

  • Andre Vill
    Andre Vill Posts: 139
    Second Anniversary 5 Likes First Answer Photogenic
    edited July 15 #2

    Hi Shaleesa!

    I think, for now, this might be difficult to do. Since if you Export data out, it should use the timezone you are currently using. Which is UTC I am guessing? 

  • Shaleesa
    Shaleesa Posts: 2
    edited July 15 #3

    Hi Shaleesa!

    I think, for now, this might be difficult to do. Since if you Export data out, it should use the timezone you are currently using. Which is UTC I am guessing? 

    Hi Andre

    Thanks for your response and sorry for my delay, I never saw an alert. I was just looking at this issue again today and realised that the exported excel data is in GMT time zone. My whole team is in GMT+8, which is the timezone set in our Pipedrive profiles. When I enter an activity in Pipedrive, the time displayed is correct. It's just the export that converts it to GMT so it's not using the timezone set in Pipedrive. Any further advice would be greatly appreciated!