Ask the Community
Groups
How to show date and time fields in my timezone in reports - Connect IT Community | Kaseya
<main> <article class="userContent"> <p>Outline</p> <p>When generating reports for the service desk module, the categories that contain date and time like <strong>Tickets.Created</strong> <strong>on</strong> and <strong>Tickets.Completed Date</strong> the hours are different from what I see in the UI or in the audit.</p> <p> Explanation</p> <p>The date and time fields in the report are all by default in UTC. This is because we have branches and each branch is in a different timezone. On the UI they are converted to the end-user timezone. In order to get the same result, you need to modify the report and use a formula to convert it from UTC to your timezone. Exago function should be used to add the offset to the UTC time.</p> <p>The <a href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fsupport.exagoinc.com%2Fhc%2Fen-us%2Farticles%2F215108908%23dateAdd" rel="noopener nofollow">DateAdd</a> exago function needs to be used. You can add them to the cell layout or double click or right-click on the column to insert a formula. <img src="/attachments/token/i4Ko1jQDMJXHoZd1bGvoO45xh/?name=inline267631053.png" width="500" height="500" data-original-height="423" data-original-width="1085" alt="image" class="embedImage-img importedEmbed-img"></img><br></p> <p><img src="/attachments/token/mwefGxem1Nt8HWDdh4LmZDfVT/?name=inline1933809273.png" width="500" height="500" alt="image" class="embedImage-img importedEmbed-img"></img></p> <p>For example use <strong>DateAdd('h', +2, {Tickets.Created On}) </strong>if you are in Italy. </p> <p>Tip</p> <p>If you only see the date in your output, format the cell to show the date and time by following this <strong><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fkaseya.vanillacommunities.com%2Fkb%2Farticles%2Faliases%2Fkaseya%2Fhc%2Fen-gb%2Farticles%2F360010856212-How-to-See-Time-Entries-in-a-Correct-Format-in-Ad-Hoc-BMS-Reports-%25C2%25A0">guide</a></strong>. <br><br></p> </article> </main>