Report on expiry dates within 1 month of present

[Datathumper]

How can I run a query that will pick the values that are dated within 1 month of the current date?

Thanks

 

[BobJacksonNCI]

You can find numerous threads on handling dates by using the Advanced Search button. That's often more effective than posting, getting an answer, clarifying the original question, etc. For example, are you looking for records dated between a month ago and today, or can your records be dated into the future and you're looking for records up to a month ago AND up to a month in the future?

Couple of things to try...
If you're looking for records from a month ago through today:
WHERE [DateField] >= DateAdd("m", -1, Date())

If your records can be future dated, etc:
WHERE [DateField] BETWEEN DateAdd("m", -1, Date()) AND DateAdd("m", 1, Date())



HTH,
Bob

 

[Datathumper]

Thanks Bob.

I got it working now. When the report opens, it asks for a number of days (from today) to report by. This works fine until I package it and distribute it with the runtime files. WHen I do this, instead of it asking for the number of days, I get an error (There was an error executing the command).

Have you seen this before?

TNX.

 

[BobJacksonNCI]

You're welcome.

I don't have any experience with packaging/distributing.

Might try searching here using the keywords packaging and runtime.

WAG (Wild ... Guess) - References?

Bob