|
hi, now+4h, other than syntax issues, would mean 4 hours into the
future from now, which is not what you want. "today" is this day at
midnight. (not sure about this but I think "today" used as a start
time is midnight a minute before 00:01 and "today" used as a due
time is today midnight a minute after 23:59). I don't think
constructs like "h" work on the fields area of an advanced filter.
The number used for dates and times equals days from some start
point, the fractional part represents time since midnight. So today
at noon would be on "today+0.5", no spaces this afternoon would be on or after after today+0.5 and on or before today-1 (after 0.5 of today, or noon, and before tomorrow) hth, Dwight On 6/7/2024 3:57 AM, Grant wrote:
-- 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 view this discussion on the web visit https://groups.google.com/d/msgid/mylifeorganized/9f208fc7-65ef-4d40-ae0b-1a78f9c45c25%40gmail.com. |
- [MLO] Need help on Advanced Filtering. Grant
- Re: [MLO] Need help on Advanced Filtering. Dwight Arthur
