Begin of the insertion# Decision needEnd of the insertion Begin of the deletion ### ContextEnd of the deletion

Begin of the insertion> A companyEnd of the insertion Begin of the deletion The "Show changes" feature proposes a way to compare between now and a relative date with a fixed time (eg. "Yesterday at 12PM"). However, this time (12PM) is not the sameEnd of the deletion in Begin of the insertionCalifornia (GMT-7) has its IT departmentEnd of the insertion Begin of the deletion all countries, andEnd of the deletion in Begin of the insertionPakistan (GMT+5).End of the insertion Begin of the deletion some regions, might technically be "the day before" or even "today".

There were challenges to the current approach (described below).End of the deletion The Begin of the insertioninstanceEnd of the insertion Begin of the deletion goal is to discuss alternatives and better ways to implement this.

### Current approach

The current approach as specified is the following:

<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/52956/content">

* When &quot;yesterday&quot;, &quot;last working day&quot;, &quot;last week&quot; or &quot;last month&quot; is selected, a &quot;Time&quot; form field (HTML input type time) appears.
* TheEnd of the deletion time is Begin of the insertionset up for California. A userEnd of the insertion Begin of the deletion enteredEnd of the deletion in Begin of the insertionPakistan wantsEnd of the insertion Begin of the deletion the default time zone of the instance, which is indicatedEnd of the deletion to Begin of the insertionconfigure a baseline for yesterday 8:00 each. Due toEnd of the insertion the Begin of the deletion right of the field.
* This defaultEnd of the deletion time Begin of the insertiondifference, yesterdayEnd of the insertion Begin of the deletion zoneEnd of the deletion is Begin of the insertion8:00End of the insertion Begin of the deletion definedEnd of the deletion in Begin of the insertionPakistan butEnd of the insertion Begin of the deletion a new setting in Administrastor → System settings → General.
* An icon toEnd of the deletion the Begin of the deletion right of the time zone indication explains that it corresponds to the default time zone, with a &quot;+1 day&quot; or &quot;-1 day&quot; if it&#39;s oneEnd of the deletion day before Begin of the insertionyesterday is 20:00End of the insertion Begin of the deletion or afterEnd of the deletion in Begin of the insertionCalifornia.End of the insertion Begin of the deletion their time zone.
* A user in a different time zone has the selected time displayed in their local time below the time field, as guideline text.End of the deletion

Begin of the insertion# Solution ideaEnd of the insertion Begin of the deletion **Challenges:**End of the deletion

* Begin of the insertionWhen creating a new baseline quereEnd of the insertion Begin of the deletion For users not in the default time zone, the time input in the actual field will not correspond to their own time.
* Filters use GMT right now. With this approach, shouldEnd of the deletion we Begin of the insertiontakeEnd of the insertion Begin of the deletion switch to this default time zone instead?

### Alternative 1: Input in local, indicate in default

Alternative 1 inverses local vs. default, as suggeted by <mention class="mention" data-id="72512" data-type="user" data-text="@Marc Alcobé">@Marc Alcobé</mention>:

<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/52958/content">

* The time is input and displayed in local time, withEnd of the deletion the Begin of the deletion localEnd of the deletion time Begin of the deletion zone, which is indicated.
* Hovering on the help icon reminds that this is the local timeEnd of the deletion zone of the Begin of the deletion user.
* The guideline text below the input reminds theEnd of the deletion user Begin of the insertionwho createsEnd of the insertion Begin of the deletion what this corresponds to inEnd of the deletion the Begin of the insertionquery
End of the insertion Begin of the deletion defaut time zone: &quot;In default time zone: 12 PM CEST -1 day.&quot;

**Challenges:**

End of the deletion * Begin of the insertionVisitors from otherEnd of the insertion Begin of the deletion The localEnd of the deletion time Begin of the insertionzones seeEnd of the insertion Begin of the deletion might not actually correspond to &quot;yesterday&quot; (as it could very well beEnd of the deletion the Begin of the deletion day before or day after), and it&#39;s less clear that the &quot;+/- day&quot; in the guideline text under the label applies to the previous field and not this one.
* Would the filters then also use the localEnd of the deletion time Begin of the insertionzone which has been added.End of the insertion Begin of the deletion to search?

### Alternative 2: Repeats Every at T

End of the deletion This Begin of the deletion approach, inspired by the way Mailbox.org handles repeating events, was evoked by <mention class="mention" data-id="87" data-type="user" data-text="@Jens Ulferts">@Jens Ulferts</mention>:

> From my perspective, as soon as you can say &quot;a specific timestamp and update that every x&quot; the problemEnd of the deletion is Begin of the deletion solved. Since the specific timestamp can have a timezone it no longer matters what to display (UTC, CET, ...) at least from a technical standpoint. This is different when you have a date which by definition doesEnd of the deletion not Begin of the insertioncalculated to their ownEnd of the insertion Begin of the deletion have timezone information making it relative. From a UI standpoint we can then do it in the localEnd of the deletion time Begin of the insertionzone because &quot;yesterday&quot; mightEnd of the insertion Begin of the deletion it wouldEnd of the deletion mean Begin of the deletion the same thing for everyone.

<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/52959/content">

**Open questions**:

* This works quite well for a weekly repetition, but how should this approach translate for the other options?
* yesterday 
* &quot;every previous day&quot;? This sounds odd.
* last working day
* last week
* &quot;Every Tuesday, at 10 AM CET&quot;? Works quite well for this case.
* last month 
* &quot;every first day of the month&quot;? This would beEnd of the deletion different Begin of the insertionthings.End of the insertion Begin of the deletion from what we have today, which is &quot;the same date but last month&quot;.
*

*End of the deletion