Date range issue singce leap year

[Robbie Doo]

Ever since 3/1/2008 I have been having problems with the date range. I don't
get the first of the month data. I even tried with some test-data for April
and get the same problem. The datas of every 1st of the month is ignored.

Does anyone else have the same problem?
Does anyone know how to correct it?

 

[Evi]

Give more details of what you are trying to do with your date ranges - the
fault may lie there.
Evi

 

[Robbie Doo]

Evi, what happened was since 3/1/2008 all the 1st of the months are ignored
in Monthly calculations. I changed the information from the 1st to the 2nd it
works fine. Example, if you're trying to pull information from 3/1/08 to
3/31/08 no information is included in the data from the 1st. Same thing for
April on.

 

[Evi]

If you put a calculated field in your date query with [MyDate]+1, does it
recognize the 1st of April then? ie would the 1st of April show as the 2nd
of April while the 31st of March would become 1st of April

This is mega-wierd!

Evi

 

[Robbie Doo]

Thank you Evi:

I used the -1 with the start date. I haven't tested the April yet though. As
soon as I try it I will let you know.

If you put a calculated field in your date query with [MyDate]+1, does it
recognize the 1st of April then? ie would the 1st of April show as the 2nd
of April while the 31st of March would become 1st of April

This is mega-wierd!

Evi

Evi, what happened was since 3/1/2008 all the 1st of the months are ignored
in Monthly calculations. I changed the information from the 1st to the 2nd it
works fine. Example, if you're trying to pull information from 3/1/08 to
3/31/08 no information is included in the data from the 1st. Same thing for
April on.

 

[Evi]

Just a thought Robbie, what are the Monthly calculations and filters you are
using? I may not be able to spot the problem but I bet one of the clever
people here can.
Some of them may be assuming that a year has 365 days or that it has exactly
52 weeks.
Evi

 

[Robbie Doo]

The filter is say Between 3/1/2008 and 3/31/2008.
What I did was -1 to the [StartDate] on the Report and +1 to the [EndDate].
I've tried March and April and seems to be working fine for now. I don't know
if down the line any problems will arise.

 

[Evi]

The filter (if it is in your criterial row of your query) should read

Between #3/1/2008# AND #3/31/2008#


but that may be what you mean -I'm just clutching at straws so that I don't
have to believe in Alien Interference! Well, if its suddenly started to work
OK again, we may never know!
Evi

The filter is say Between 3/1/2008 and 3/31/2008.
What I did was -1 to the [StartDate] on the Report and +1 to the [EndDate].
I've tried March and April and seems to be working fine for now. I don't know
if down the line any problems will arise.

Just a thought Robbie, what are the Monthly calculations and filters you are
using? I may not be able to spot the problem but I bet one of the clever
people here can.
Some of them may be assuming that a year has 365 days or that it has exactly
52 weeks.
Evi

2nd
it thing
for ranges -
the

 

[Chuck]

The filter is say Between 3/1/2008 and 3/31/2008.
What I did was -1 to the [StartDate] on the Report and +1 to the [EndDate].
I've tried March and April and seems to be working fine for now. I don't know
if down the line any problems will arise.

If you try Between #3/4/2008# and #4/4/2008# does it include data for 3/4/2008
and/or 4/4/2008?

Chuck

 

[Robbie Doo]

Before the changes I didn't try that range. However, after the changes all
the months (1st to the 30th/31st) are working fine.

The filter is say Between 3/1/2008 and 3/31/2008.
What I did was -1 to the [StartDate] on the Report and +1 to the [EndDate].
I've tried March and April and seems to be working fine for now. I don't know
if down the line any problems will arise.

If you try Between #3/4/2008# and #4/4/2008# does it include data for 3/4/2008
and/or 4/4/2008?

Chuck

 

[Robbie Doo]

Chuck:

with the + and - addition I tried all the date ranges possible and it works
just fine.
Like Evi said it's weird.

The filter is say Between 3/1/2008 and 3/31/2008.
What I did was -1 to the [StartDate] on the Report and +1 to the [EndDate].
I've tried March and April and seems to be working fine for now. I don't know
if down the line any problems will arise.

If you try Between #3/4/2008# and #4/4/2008# does it include data for 3/4/2008
and/or 4/4/2008?

Chuck