https://community.splunk.com/t5/Splunk-Search/How-to-fix-timechart-issue-with-dates-involved-in-between-a/m-p/126892#M34379 <P>Hi guys, we have a problem when we try to use timecharts that involve dates having in between a daylight saving time change.</P> <P>If I change my timezone to GMT in account preferences, the timecharts query works fine, but if I do a span=1d it shows September 6 twice and doesn't show September 7.</P> <P>If i change my timezone to GMT-4 Santiago, the query fails showing NaN numbers.</P> <P>The query is</P> <BLOCKQUOTE> <P>: sourcetype=varnish<BR /> account_id="50aa2711a6884125020019f1"<BR /> | timechart span=1d<BR /> distinct_count(customer_id)</P> </BLOCKQUOTE> <P>All our logs has time fields on UTC.</P> <P>any ideas?</P> <P>Thanks!.</P> Mon, 28 Sep 2020 17:35:51 GMT csepulveda 2020-09-28T17:35:51Z https://community.splunk.com/t5/Splunk-Search/How-to-fix-timechart-issue-with-dates-involved-in-between-a/m-p/126892#M34379 <P>Hi guys, we have a problem when we try to use timecharts that involve dates having in between a daylight saving time change.</P> <P>If I change my timezone to GMT in account preferences, the timecharts query works fine, but if I do a span=1d it shows September 6 twice and doesn't show September 7.</P> <P>If i change my timezone to GMT-4 Santiago, the query fails showing NaN numbers.</P> <P>The query is</P> <BLOCKQUOTE> <P>: sourcetype=varnish<BR /> account_id="50aa2711a6884125020019f1"<BR /> | timechart span=1d<BR /> distinct_count(customer_id)</P> </BLOCKQUOTE> <P>All our logs has time fields on UTC.</P> <P>any ideas?</P> <P>Thanks!.</P> Mon, 28 Sep 2020 17:35:51 GMT https://community.splunk.com/t5/Splunk-Search/How-to-fix-timechart-issue-with-dates-involved-in-between-a/m-p/126892#M34379 csepulveda 2020-09-28T17:35:51Z https://community.splunk.com/t5/Splunk-Search/How-to-fix-timechart-issue-with-dates-involved-in-between-a/m-p/126893#M34380 <P>You might be running into this problem:</P> <P><A href="http://answers.splunk.com/answers/155320/why-is-the-search-app-time-range-picker-defaulting-to-2001-even-if-i-specify-another-date-and-time.html">http://answers.splunk.com/answers/155320/why-is-the-search-app-time-range-picker-defaulting-to-2001-even-if-i-specify-another-date-and-time.html</A></P> <P>There's something magic about September 6, based on the comments in that thread.</P> Tue, 16 Sep 2014 16:54:36 GMT https://community.splunk.com/t5/Splunk-Search/How-to-fix-timechart-issue-with-dates-involved-in-between-a/m-p/126893#M34380 aweitzman 2014-09-16T16:54:36Z