Expiration Date criteria
I'm working on a query with an expiration date field [ExpDt]. I need it to display all records that are a month away from expiration, or have been expired for any amount of time so renewal notifications can be sent out. So far I'm still getting expiration dates from 2008 through 2014.
What expression should I enter in the criteria area?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
The table I have keeps track of the date of their current training and when it expires. What I want is in a report that I generate, which has the users listed with the date of their IA expiration to have the users who are a month from expiration to be in yellow or some other color and the users who are past expiration to be red.
I need a query that will show me every employee who has credentials (regardless of type I.e. BLS, TNCC, etc) that will expire sometime in the next 6 months.
I have created a database that lists employee first name, employee last name, BLS expiration date, TNCC expiration date and several other credential expiration dates. Each is unique to the employee listed on the form and the expiration dates are in short date/time format.
I need a query that will show me every employee who has credentials (regardless of type i.e. BLS, TNCC, etc) that will expire sometime in the next 6 months
=IIf([Expiration Date]<Date(),"Expired",IIf([Expiration Date]=Date(),"Expires today","No"))
When in form view the box always says Expired no matter what the date is in [Expiration Date]
I don't see anything wrong with my IIF statement. plz
I would like to compare the "maindate" to an "expiration date"
I would like this to show up 60 days before the expiration date expires. for example if the expiration is 11-30-2010 I I would like a warning to appear on 08-30-2010 stating that the item is about to expire
I have a question that I am hoping to get a hint on.
I have a field that is an expiration date. At any one time, only one row should have a blank expiration date field, all other rows(for the same product let's say) should have this column populated.
I now want to pull only those records, which are not expired (blank column) but I keep receiving an error on my query, whenever I use "", " ", '', or ' ' in the criteria.
My question is, how can I retrive only non-expired rows
The table containing training courses with their requirements and frequency is called "Course Requirements". Within this table I have a "Frequency" field (1, 2, 3, 4, 5, 6) and another field "FrequencyPeriod" (Year, Month, Initial, As Needed).
What I'd like for the Expiration Date on the form to do: Use [ScheduledTraining].[Training Date] and look at both the [CourseRequirements].[Frequency] & [CourseRequirements].[FrequencyPeriod] to populate the Expiration Date
The first IF statement is for my “IsPending” box which is for quotes that have been sent the customer but have not yet been confirmed. I want this box to be checked as long as the quote is both not active and before the expiration date.
The “Expiration Date” is determined by the date the record was made plus 30 days and is already calculated. If a quote accepted before theexpiration date then it will have a button to check the “IsActive” yes/no box unchecking “IsPending” box.
I think this IF statement is right, however I am not sure where to put it.
IIf( [Expiration Date] >= Now() and [IsActive] = -1,1,-1)