Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Expiration Dates..

Status
Not open for further replies.
HiHeidi

HiHeidi

Technical User
Aug 16, 2001
15
US
I think my brain is still in the French Quarter from the weekend, but I'm having trouble conceptualizing how I need to report on Expiration dates.

I need to build a selection criteria for a monthly report on lease expiration dates. I need to pull those leases that expire in 12 months, 6 months and 30 days. HELP!

I built a formula field that can take either the currentdate or the Lease.expire_date and add 183 days (6 months), 365 days (etc), but I'm drawing a complete blank on how I should link this to the expiration date. Anyone out there a little more alert and functional than I am today?

Heidi
 
Status
Not open for further replies.

Similar threads

mart10
  • Locked
  • Question
table calc between dates
Replies
0
Views
163
mart10
mart10
kernal
  • Locked
  • Question
Need to Calculate an Expiration Date depending on Purchase Dates for a Membership
Replies
5
Views
278
kernal
kernal
LZido
  • Locked
  • Question
Need multiple dates with data on one row.
Replies
1
Views
195
Charliy
Charliy
ginaburg
  • Locked
  • Question
Comparing dates by using other criteria
Replies
8
Views
313
ginaburg
ginaburg
borisbe
  • Locked
  • Question
Calculating the Number of Weeks between Dates. Only held on certain days of week (Problem: Holidays)
Replies
1
Views
219
Charliy
Charliy

Part and Inventory Search

Sponsor

Back
Top