Need filter argument "has no time"

51 views
Skip to first unread message

Alexis

unread,
Dec 13, 2016, 11:39:38 AM12/13/16
to MyLifeOrganized
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

Dwight

unread,
Dec 13, 2016, 1:00:09 PM12/13/16
to mylifeo...@googlegroups.com
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
> --
> 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 mylifeorganiz...@googlegroups.com
> <mailto:mylifeorganiz...@googlegroups.com>.
> To post to this group, send email to mylifeo...@googlegroups.com
> <mailto:mylifeo...@googlegroups.com>.
> 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/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>.
> For more options, visit https://groups.google.com/d/optout.

Alexis

unread,
Dec 14, 2016, 4:55:05 AM12/14/16
to MyLifeOrganized
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. 

Dwight

unread,
Dec 15, 2016, 12:41:52 AM12/15/16
to mylifeo...@googlegroups.com
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
> > an email to mylifeorganiz...@googlegroups.com <javascript:>
> > <mailto:mylifeorganiz...@googlegroups.com <javascript:>>.
> > To post to this group, send email to mylifeo...@googlegroups.com
> <javascript:>
> > <mailto:mylifeo...@googlegroups.com <javascript:>>.
> <https://groups.google.com/group/mylifeorganized>.
> <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/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 mylifeorganiz...@googlegroups.com
> <mailto:mylifeorganiz...@googlegroups.com>.
> To post to this group, send email to mylifeo...@googlegroups.com
> <mailto:mylifeo...@googlegroups.com>.
> 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>.
Reply all
Reply to author
Forward
0 new messages