ACCESS FEED: RE: [MS_AccessPros] Re: filter this year vs. ytd

Rabu, 15 Mei 2013

RE: [MS_AccessPros] Re: filter this year vs. ytd

The mystery becomes clear if you apply the YTD filter and then go to
Advanced Filter/Sort to examine the result.

Some not-very-clever person has implemented this filter for YTD:

Year([DateField]) = Year(Date()) AND
Month([DateField]) <= Month(Date()) AND
Day([DateField]) <= Day(Date())

This will exclude any records from past months where the day number is past
the current day in this month. on June 1 you will only get records for 6
days!!!

Of course, the filter should be:

Year([DateField]) = Year(Date()) AND [DateField] <= Date()

Definitely a bug - thanks for reporting it, John. Do you have a URL to
reference it so we can all go there and vote? I understand this has some
bearing on how seriously it is taken.

Cheers,
Graham

--- Bill Mosca wrote:

Liz

I just tested and came up with weird results, too. In my table I have 62
records for 2013. When I use This Year as the filter, I get all 63. When I
use Year To Date I get 27. I can't see any kind of pattern as to which ones
are excluded. It seems random. I even sorted the dates to see if the first
27 in the bigger set was the same, but they are not.

Looks like a bug to me!

Bill Mosca.

--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood
<liz_ravenwood@...> wrote:
>
> Pros, It's another weird day in paradise.
>
> I've never done this, but a user showed me and I'm having the same
experience. Right click on a date field and she says this year - it gives
her 8437. Right click on the same field and say ytd, and it gives 4934. I
even did a clear filters before I tried it and I get the same thing.
>
> An unmatched shows a record that clearly has the date 1/13/2013. I didn't
check any others... (is it cause 13 is unlucky? ;-) )
>
> Weird!
>
> Respectfully,
> Liz Ravenwood
> Programmer/Analyst
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com<http://www.beaerospace.com>
>
> This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you
are not the intended recipient, please contact the sender by reply e-mail
and destroy all copies of the original message.
>
>
> [Non-text portions of this message have been removed]
>