Date range issue singce leap year

  • Thread starter Thread starter Robbie Doo
  • Start date Start date
R

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?
 
Give more details of what you are trying to do with your date ranges - the
fault may lie there.
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.
 
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
 
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.

Evi said:
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 said:
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.
Click to expand...
Click to expand...
 
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
 
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.
 
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

Robbie Doo said:
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 said:
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
Click to expand...
Click to expand...
 
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.
Click to expand...

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
 
Before the changes I didn't try that range. However, after the changes all
the months (1st to the 30th/31st) are working fine.

Chuck said:
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.
Click to expand...

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
Click to expand...
 
Chuck:

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

Chuck said:
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.
Click to expand...

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
Click to expand...
 
Back
Top