Listing dates greater than 6 months from today

[Guest]

I have written criteria as follows....<[enter date greater than 6 months]....
when run I enter a date 6 months from today and it shows the records I need.
I would like this to be simplified....but can't figure out how. What I would
like is when I run the query it automatically calculates and shows only those
records that are greater than 6 months from today - rather than my inputting
a date param each time. The field is a standard mm/dd/yyyy field. I am not
familiar with using the sql in the background...but can try if that is the
assistance provided. If this does not make sense let me know--- thank you in
advance for your help!

 

[Guest]

Use one of these as your criteria --
< Date()-180
OR
< DateAdd("m", -6, Date())

These are 180 days or 6 months.

 

[Allen Browne]

Try:

DateAdd("m", 6, Date())

Or, if you meant more than 6 months ago:
< DateAdd("m", -6, Date())

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have written criteria as follows....<[enter date greater than 6
months]....
when run I enter a date 6 months from today and it shows the records I
need.
I would like this to be simplified....but can't figure out how. What I
would
like is when I run the query it automatically calculates and shows only
those
records that are greater than 6 months from today - rather than my
inputting
a date param each time. The field is a standard mm/dd/yyyy field. I am
not
familiar with using the sql in the background...but can try if that is the
assistance provided. If this does not make sense let me know--- thank you
in
advance for your help!

 

[Guest]

Perfect!!! Many thanks!!

Use one of these as your criteria --
< Date()-180
OR
< DateAdd("m", -6, Date())

These are 180 days or 6 months.

I have written criteria as follows....<[enter date greater than 6 months]....
when run I enter a date 6 months from today and it shows the records I need.
I would like this to be simplified....but can't figure out how. What I would
like is when I run the query it automatically calculates and shows only those
records that are greater than 6 months from today - rather than my inputting
a date param each time. The field is a standard mm/dd/yyyy field. I am not
familiar with using the sql in the background...but can try if that is the
assistance provided. If this does not make sense let me know--- thank you in
advance for your help!