Hi, Alexis. No screenshot but here is the filter, all tested and debugged:
((DueDateTime before Today+2) AND ((DueDateTime onOrAfter Today+1) OR
(DueDateTime OnOrBefore Today+0.00001)
Let me explain that last part. "OnOrBefore Today" will include the past
plus anything scheduled today regardless of what time if any it's
scheduled. "OnOrBefore Today+0.25" will include the past plus anything
scheduled for today up through 6:00 am (because 0.25 of a day is 6
hours). So to eliminate anything scheduled for any time today regardless
of what time it's scheduled for and leave only today's tasks that have
no time, you have to code Today plus some number, but the number has to
be smaller than the earliest time anybody might schedule for a task.
0.00001 of a day, if I did my arithmetic correctly, is 0.8 of a second,
or 00:00:00.8 which is pretty early in the day.
Note that if someone specified a due date and sets a time as well, but
the time is midnight, you cannot tell that apart from having no time at all.
Apology: in my first reply I showed coding with a day followed by a
time, like Today+1 00:00 - this is bogus. I should always test my
solutions before posting them but this time I didn't.You have to code
today plus some number where the integer part is a day and the
fractional part is a part of a day, like Today+1.25 - also, 1.00000 is
treated as the same as 1 so there is no way to distinguish "tomorrow at
midnight" from "tomorrow all day"
Finally, Alexis, if you have any trouble following all of this
discussion feel free to ignore it and just copy the filter.
-Dwight
On 12/14/2016 4:55 AM, Alexis wrote:
Thank you Dwight. That is very confusing. Would it be possible for you
to poste a screenshot of the window "Setup Advanced Filtering" with the
settings you wrote?
I have for example no idea how to find the function "today at midnight"
Thank You.
Am Dienstag, 13. Dezember 2016 19:00:09 UTC+1 schrieb Dwight:
Alexis: In MLO, "today with no time" is coded exactly the same as
"today
at midnight (00:00)". If you rewrite your problem statement using
"today
at midnight" it becomes easier to solve. If I am understanding you, you
do want to see tasks with due date tomorrow all day (0000-2359), you do
not want to see tasks due today after midnight (0001-2359) and you do
want to see tasks today midnight and before. So your test would be
(((dueDateTime onOrAfter Today+1 00:00) AND (dueDateTime Before
Today+2)) OR (dueDateTime onOrBefore Today 00:00))
The places where I coded 00:00 can probably be omitted but I put it in
to keep myself less confused.
It's possible that you did not want to exclude tasks that were due
today
at a time that has already passed, in which case you would substitute
Now for the last Today.(((dueDateTime onOrAfter Today+1 00:00) AND
(dueDateTime Before Today+2)) OR (dueDateTime onOrBefore Now))
Or if you wanted to include tasks due earlier today but only if they
were overdue by 3 hours or more you could use Now-0.125 because three
hours is 1/8 of a day and 1/8 = 0.125.
-Dwight
On 12/13/2016 11:39 AM, Alexis wrote:
> I would like to see tasks (using advanced filter) which are due on
and
> before tomorrow (Today +1) but i don´t want to see tasks which are
due
> today in 2 hours. (has a time). It would be easy if there would be
the
> argument (has no time). But i can´t find it and can´t think of any
> workaround. Any ideas?
>
> Thank You
> Alexis
>
> --
> You received this message because you are subscribed to the Google
> Groups "MyLifeOrganized" group.
> To unsubscribe from this group and stop receiving emails from it,
send
> an email to [email protected] <javascript:>
> <mailto:[email protected] <javascript:>>.
> To post to this group, send email to [email protected]
<javascript:>
> <mailto:[email protected] <javascript:>>.
> Visit this group at
https://groups.google.com/group/mylifeorganized
<https://groups.google.com/group/mylifeorganized>.
> To view this discussion on the web visit
>
https://groups.google.com/d/msgid/mylifeorganized/41d9c995-e710-42e1-b7ed-355a29cbdbad%40googlegroups.com
<https://groups.google.com/d/msgid/mylifeorganized/41d9c995-e710-42e1-b7ed-355a29cbdbad%40googlegroups.com>
>
<https://groups.google.com/d/msgid/mylifeorganized/41d9c995-e710-42e1-b7ed-355a29cbdbad%40googlegroups.com?utm_medium=email&utm_source=footer
<https://groups.google.com/d/msgid/mylifeorganized/41d9c995-e710-42e1-b7ed-355a29cbdbad%40googlegroups.com?utm_medium=email&utm_source=footer>>.
> For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
You received this message because you are subscribed to the Google
Groups "MyLifeOrganized" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at https://groups.google.com/group/mylifeorganized.
To view this discussion on the web visit
https://groups.google.com/d/msgid/mylifeorganized/cfdeb3f4-e047-458d-a14c-786e7c0a552f%40googlegroups.com
<https://groups.google.com/d/msgid/mylifeorganized/cfdeb3f4-e047-458d-a14c-786e7c0a552f%40googlegroups.com?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"MyLifeOrganized" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/mylifeorganized.
To view this discussion on the web visit
https://groups.google.com/d/msgid/mylifeorganized/4e065d84-374f-60a1-a979-4a2a4dc41651%40dwightarthur.us.
For more options, visit https://groups.google.com/d/optout.
