Hello All,
Why is Today not equal to Today???
So, if I filter a form with a date field, which contains today's date, where "Filter = Date()", it returns the record with today's date. However, if I use a formula to find the last day of the week, and convert that to a date
, which gives me today's date, since it is Saturday, the filter returns no results.
Somehow, Today does not equal the computed value of Today...
I am trying to filter a form of items that are due by the end of each week, including the current day, with the start of the week beginning Sunday, which is the default. If an item was not completed the previous week, it will remain on the list until completion, so the filter would something like
.
Thoughts?
Why is Today not equal to Today???
So, if I filter a form with a date field, which contains today's date, where "Filter = Date()", it returns the record with today's date. However, if I use a formula to find the last day of the week, and convert that to a date
Code:
dDate = (Date - WeekDay(Date) + 7)
Somehow, Today does not equal the computed value of Today...
I am trying to filter a form of items that are due by the end of each week, including the current day, with the start of the week beginning Sunday, which is the default. If an item was not completed the previous week, it will remain on the list until completion, so the filter would something like
Code:
"[DueDate] <= " & EndOfTheCurrentWeek & ""
Thoughts?