topic Re: how to get starttime in Dynatrace DQL in DQL https://community.dynatrace.com/t5/DQL/how-to-get-starttime-in-Dynatrace-DQL/m-p/253342#M1139 <P>Hello,</P><P>In DQL you can add/subtract timestamps and durations to get a new timestamp (see screenshot). Can you share the full query you are using?&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CameronLeong_0-1723583616478.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/21759i11E47DE8EE494AAF/image-size/medium?v=v2&amp;px=400" role="button" title="CameronLeong_0-1723583616478.png" alt="CameronLeong_0-1723583616478.png" /></span></P><P>&nbsp;</P> Tue, 13 Aug 2024 21:14:42 GMT Cameron-Leong 2024-08-13T21:14:42Z how to get starttime in Dynatrace DQL https://community.dynatrace.com/t5/DQL/how-to-get-starttime-in-Dynatrace-DQL/m-p/253168#M1138 <P>Hi</P><P>&nbsp;</P><P>I have endtime (timestamp format) and duration (duration format), i need starttime by redcucing the duration from endtime. I tried below but the output was wrong. Both start and end values are same. can someone help.</P><P>&nbsp;</P><P>| fieldsAdd StartTime = EndTime - durationMillis</P> Mon, 12 Aug 2024 13:23:19 GMT https://community.dynatrace.com/t5/DQL/how-to-get-starttime-in-Dynatrace-DQL/m-p/253168#M1138 nikhilchandra 2024-08-12T13:23:19Z Re: how to get starttime in Dynatrace DQL https://community.dynatrace.com/t5/DQL/how-to-get-starttime-in-Dynatrace-DQL/m-p/253342#M1139 <P>Hello,</P><P>In DQL you can add/subtract timestamps and durations to get a new timestamp (see screenshot). Can you share the full query you are using?&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CameronLeong_0-1723583616478.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/21759i11E47DE8EE494AAF/image-size/medium?v=v2&amp;px=400" role="button" title="CameronLeong_0-1723583616478.png" alt="CameronLeong_0-1723583616478.png" /></span></P><P>&nbsp;</P> Tue, 13 Aug 2024 21:14:42 GMT https://community.dynatrace.com/t5/DQL/how-to-get-starttime-in-Dynatrace-DQL/m-p/253342#M1139 Cameron-Leong 2024-08-13T21:14:42Z