Date filter

  • Thread starter Thread starter user
  • Start date Start date
U

user

Hello

I have an access database where I only want data retrieve if dates are
greater than or equal to 2/28/2008. But, the month can vary as well as year,
just the day remains same.
 
Also, I should mention that I don't want 3/12/08 just b/c it's greater than
2/28/08. For each month, I only want data if the date is greater than
2/28/08. I only used Feb as an example. Hope that make sense.
 
Also, I should mention that I don't want 3/12/08 just b/c it's greater than
2/28/08. For each month, I only want data if the date is greater than
2/28/08. I only used Feb as an example. Hope that make sense.
Click to expand...

It's still not clear what you want.
Do you want any date of any month and year that is the 29th, 30th or
31st day of the month?

As criteria in a query?
Where Day([DateField]) > 28
 
SQL --
WHERE Format([YourDateField], "d") >=28

Design view --
FIELD -- MyDate: Format([YourDateField], "d")
CRITERIA -- >=28
 
yes, that's what I want. Any date to show the month/date/year as long as
it's 28,29,30,31. I put the criteria Where Day([DateField])>28, but then the
month and year disappers. I need the full date (m/d/yy) to show.

--
Thanks


fredg said:
Also, I should mention that I don't want 3/12/08 just b/c it's greater than
2/28/08. For each month, I only want data if the date is greater than
2/28/08. I only used Feb as an example. Hope that make sense.
Click to expand...

It's still not clear what you want.
Do you want any date of any month and year that is the 29th, 30th or
31st day of the month?

As criteria in a query?
Where Day([DateField]) > 28
Click to expand...
 
Karl

I tried this but only the day greater than 28 shows, i still don't see the
month & year.
--
Thanks


KARL DEWEY said:
SQL --
WHERE Format([YourDateField], "d") >=28

Design view --
FIELD -- MyDate: Format([YourDateField], "d")
CRITERIA -- >=28

user said:
Also, I should mention that I don't want 3/12/08 just b/c it's greater than
2/28/08. For each month, I only want data if the date is greater than
2/28/08. I only used Feb as an example. Hope that make sense.
Click to expand...
Click to expand...
 
Karl

I tried this but only the day greater than 28 shows, i still don't see the
month & year.
Click to expand...

Add your full date field into your query in a different column. If
you don't want to see the Day-only field, turn off its Show checkbox.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Back
Top