date criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following field 6 mos Review: [RECEIVED DATE] + 180. I would like
to add criteria to select the records ready for review for a specific month
(ex. February or 2/1/07 to 2/28/07) Any suggestions would be greatly
appreciated.
 
I actually want to add criteria to this field that would show all records
from a certain and any previous dates when another field is null (i.e. Audit
Date-6 mos). I would like to make sure we get all records that may have
missed the 6 mos mark.
 
OK...I am slowing figuring this out. I changed the field as follows: 6 mos
Review: DateAdd("m",6,[RECEIVED DATE]), which results in the actual 6 months
and not an estimated 6 months by just adding 180 days. However, I am still
working on the criteria/parameter to gather records that show the 6 month
audit date for a specific month and any previous months that were missed. I
believe this will be a temporary parameter until we are current.

JamieM said:
I actually want to add criteria to this field that would show all records
from a certain and any previous dates when another field is null (i.e. Audit
Date-6 mos). I would like to make sure we get all records that may have
missed the 6 mos mark.

JamieM said:
I have the following field 6 mos Review: [RECEIVED DATE] + 180. I would like
to add criteria to select the records ready for review for a specific month
(ex. February or 2/1/07 to 2/28/07) Any suggestions would be greatly
appreciated.
Click to expand...
Click to expand...
 
I have the following field 6 mos Review: [RECEIVED DATE] + 180. I would like
to add criteria to select the records ready for review for a specific month
(ex. February or 2/1/07 to 2/28/07) Any suggestions would be greatly
appreciated.
Click to expand...

I'd suggest putting a calculated field in the table

Review: DateAdd("m", 6, [Received Date])

and put a criterion on it such as
= DateSerial([Enter year:], [Enter month number:], 1) AND < DateSerial([Enter year:], [Enter month number:] + 1, 1)
Click to expand...


John W. Vinson[MVP]
 
Back
Top