Hi Mark A -- Thanks for suggestions. I honest-to-God just can't figure this out. What seems so strange is that I can
see the value of $StartDate, since it's sitting there right at the top of the item as a displayed Key Attribute. So in the results of a query searching for $StartDate in the past, I see an item whose $StartDate, right in front of me, is a month in the future. Go figure.
So here is my workaround, on which I seek your confirmation:
- I'm going to stop messing around with $StartDate. Instead I'm going to create a new date-type value, $StartingDate
- By default, its value will be "never"
- I will add specific values only when I want to set something to be suppressed until its time arrives
- And I will have a query, $StartingDate<date("today")
Now the question: for the majority of items that have no value, or with "never" as their $StartingDate, will they be
included in my query. That is, is "never" an
earlier time than "today"? Or will the query be limited to items with some non-default value in $StartingDate?
I can see how this looks with trial and error, but looking for the Official Answer? And, if I want to exclude "never" items, does the query need to be: $StartingDate & $StartingDate<date("today") Or does the second part of that query imply the first? Thanks
Further head-scratcher update: I wonder if Mark A or Mark B, or other actual coders, can explain this behavior to me.
I have the new date attribute $StartingDate. The default value for the attribute is "never". Of the 1000+ items in the file, all but two have the default value. The other two have values in the future. But:
- This query, $StartingDate>date("today") , copied verbatim from the query box, returns all notes except the two with future values, which is to say all notes with "never" values; while
- This query, $StartingDate!>date("today"), again copied verbatim, returns only the two notes whose $StartingDate has not yet arrived.
This is exactly the opposite of what I would expect. To me, the first query means "show me everything whose date is
after today, and the second means "show me everything whose date is
not after today." And the results seem just the reverse.
What am I missing?