date and above 1

[tourguy]

I have a table called "table1". Within table1, i have a field name called "date inputted". In query, I want to try to pull out all of the dates older than 3 mnths from today. So today is March 12... what I want is pull out any date that is 3 mnths and above from today.

 

[mgolla]

Put this as your criteria:

DateDiff("d",Date,[table1]![date inputted])>=90



HTH
Mike

 

[tourguy]

I'm having problem getting this to work... The message error is "Data type mismatch in criteria expression". I tried modifying the things, but still popping up the same error.

 

[mgolla]

Is your "date inputted" field a date format or text?

if it is text you will need to add a format statement:

DateDiff("d",Date,Format([table1]![date inputted],"Short Date"))>=90

Or change the field to a date/time field

HTH
Mike

 

[tourguy]

it is date formatted as 99/99/00;0;_

 

[BobJacksonNCI]

Try:

DateDiff("d",Date(),[table1]![date inputted])>=90

Access may discard the () after Date, but you must type them in.

Also, it is not clear whether you want all entries older than three months ago, "older than 3 mnths from today", or if you want entries from three months ago through today, "any date that is 3 mnths and above from today".

The code above should give you all entries that were entered 90 days ago or older.


HTH,
Bob

 

[tourguy]

Thanks so much!!