Subtract 1 month from user inputed date?

[dmbfan715]

Hi,

I need to pull records that are >= User Inputted Date - 1 month.

My query keeps giving me the error message "Expression is typed incorrectly or is too complex to be evaluated.

How do I do this calculation? Thanks in advance!

Shivani

 

[BanditWk]

If you're using code:

DateAdd("m", -1, DateField)

If you're using a query:

Format(DatePart("m", DateField)-1 & "/" & DatePart("d", DateField) & "/" & DatePart("yyyy", DateField), "Short Date&quot

Now, what I've found to be the easiest, is use the code version and apply to hidden dates for the query to draw from.

But, that's up to you.

HTH Roy McCafferty
aka BanditWk

Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)

"I do this because I know I can - no need to send gifts - just send me a smile to show me that I've helped." ~ seen on a cardboard sign held by Roy McCafferty on a corner in Las Vegas

 

[dmbfan715]

Thanks for the quick response. I'm do I do the hidden dates method you mentioned? Also, don't user inputs have to like: [enter date], for example?

Thanks,
Shivani

 

[dmbfan715]

oops meant to say "How do I use the hidden dates method?"

 

[dmbfan715]

Update: I got the query only method working, but still curious about the code method.