Topics Search

Expiration Date criteria

Expiration Date criteria
Views: 294
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:

Similar posts...


Date of expiration change color

Date of expiration change color Icon
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

Query for expiring items Icon
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.

IIF statement not working properly

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

Date Formula - AM I EXPIRED! Icon
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

Expiration date not working Icon
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

A Date Question Icon
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

Calculate Due Date based on fields from another table Icon
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

Field content based on date calculation

Field content based on date calculation Icon
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

If Statements help....

If Statements help.... Icon
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)

Calculating number of days from input.

Calculating number of days from input. Icon
How do you calculate the number of days from the original date the the record was recorded.

for example

You have a text box the has three options 90 day, 180 days, and 360 days. And a date and time box to true to show the expiration date.

How do I get the database to show the to calculate the expiration date depending on the number of days that was selected.