Competed after Star Toggle Date

[Pro Boxing Dad]

I am trying to create a view that shows me which tasks were completed AFTER the date I Starred a task. 

This tells me "These are the tasks I finished one or more days after I had initially intended to" 

So I created a view that gets me very, very close. The view is as follows:

CompleteDateStartTime NOT ON StarToggleDateTime

Pretty simple, eh? However what's affecting this is the DateTime parameter. Meaning it's taking TIME in to consideration. So if I Star at task at 9:15am and then complete it at 10:00am that same day, it's still showing up in the result set. 

See below as my example.    

dd

Is there anyway around this? I tried looking for options to exclude the time but cannot come up with anything. Thanks!

[Dwight Arthur]

Hi, I'm not sure if I entirely understand your objective, but if I do, how about

Completeddatetime ON OR AFTER Startoggledatetime + 0.75

(I don't have access to a computer today for checking so there may be syntax errors, sorry)

You should adjust the 0.75 to match your lifestyle. What this says is that if you complete a task within 18 hours (24 x 0.75) after starring it, it's normal, if it takes longer it goes on to the list. Side benefit: if you star something at noon and complete it at 1 am, it will count as "same day" because it's less than 18 hours

Let know if this is not what you wanted

-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.
To post to this group, send email to 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/7f5c9617-3074-42a1-9025-272bed45e55c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Pro Boxing Dad]

Thanks for the response.. So basically I use Stars as 'focus mode'. Meaning I star the next five things I want to complete. I'll average 9-11 stars per day.

What I'm wanting to understand is, "Out of the things I committed myself to focus on, which ones did I end up changing my mind for some reason and removing the star, and/or which ones did I leave starred and not complete?"

This gives me some additional insight for a scorecard I create, which tells me if I'm committing to things properly, if my estimates are sound, etc. It's an exception...so really care how many tasks were starred but not completed? From there I'll slice the data but I'm having a hard time just getting that due to the 'time' property. I hope this makes sense. I will take a look at what you suggested below and let you know if it work.