Topics Search

Expiration Date criteria

Expiration Date criteria
Views: 271
I have tried a few different expressions I've found on this site, but nothing is working.
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?
Sponsored Links:

More topics

 

Date of expiration change color

Preview
I've created a data base to keep track of my users. My users have to do a yearly training about keeping the network safe and if its not done they loose their access.

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.
 

Query for expiring items

Preview
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 theemployee 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.
 

Query for expiring items

Preview
I am a bit confused about what I'm sure is a very basic question.

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 statement not working properly

Preview
I currently have a field in a table called expiration date in which a dates are stored. In a form I added a text box that has an IIF statement

=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
 

Date Formula - AM I EXPIRED!

Preview
I have been trying to figure out a formula to determine if an item is expired.

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
 

Expiration date not working

Preview
My expiration date query is not working for some reason. It brings back nothing which I know is untrue. Basically I"m trying to create a query that will tell me when patient's prescriptions expire. 30 days from the date of the script but when I run it. it gives me nothing. : (
 

A Date Question

Preview
to you all.
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
 

Calculate Due Date based on fields from another table

Preview
I have a form for entering safety training which includes Training Date and Expiration Date, this form is called "Scheduled Training".

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
 

If Statements help....

Preview
I am working on the order status formula for my Quote/order database. However I am not sure where I can use the If statement to do what I want. I have several yes/no boxes which depending on the status of the order will have different checked and unchecked boxes.

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)
 

Field content based on date calculation

Preview
I have a field in a table that contains the expiration date of my contractors' insurance certificates. I would like to have a field that returns a "Current" or "Expired" value based on whether the current date is before or after the expiration date. How would I do this