Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Create report for when a date is 3 years old
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 10-25-2022, 07:28 AM
Daronovitz Daronovitz is offline Create report for when a date is 3 years old Windows 10 Create report for when a date is 3 years old Office 2019
Novice
Create report for when a date is 3 years old 		 
Join Date: Jul 2022
Posts: 13
Daronovitz is on a distinguished road
Default Create report for when a date is 3 years old
I have a large database workbook with a lot of information, but I am only concerned with one column: loan date. I want to track when the loan date is greater than 3 years old. Conditional formatting for this would be helpful, but preferably I'd like to create a report for when a date becomes 3 years old.
Reply With Quote
  #2  
Old 10-25-2022, 04:51 PM
Logit Logit is offline Create report for when a date is 3 years old Windows 10 Create report for when a date is 3 years old Office 2007
Expert
  
Join Date: Jan 2017
Posts: 533
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
You could FILTER that column for dates that match 3 yrs old.
Then copy/paste the results to another sheet ... and / or ... print
the filtered sheet.
Reply With Quote
  #3  
Old 10-25-2022, 10:26 PM
ArviLaanemets ArviLaanemets is offline Create report for when a date is 3 years old Windows 8 Create report for when a date is 3 years old Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
One possibility is to create an ODBC query based on your data table, which returns list of loans >= 3 years old to another sheet in same workbook. You can set this query to be refreshed whenever the workbook is opened.
Reply With Quote
  #4  
Old 10-25-2022, 11:53 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Create report for when a date is 3 years old Windows 10 Create report for when a date is 3 years old Office 2021
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,770
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default
There are also easy Power Query possibilities. If you post a sample sheet ( no pics please) we can work on it
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 10-26-2022, 02:02 AM
p45cal's Avatar
p45cal p45cal is offline Create report for when a date is 3 years old Windows 10 Create report for when a date is 3 years old Office 2019
Expert
  
Join Date: Apr 2014
Posts: 866
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Your conditional formatting could be based on something along the lines of:
Code:
=$A2<=DATE(YEAR(TODAY())-3,MONTH(TODAY()),DAY(TODAY()))
where A2 contains your date.
Reply With Quote
  #6  
Old 11-01-2022, 02:42 PM
mrgramm mrgramm is offline Create report for when a date is 3 years old Windows 10 Create report for when a date is 3 years old Office 2021
Novice
  
Join Date: Jan 2020
Posts: 7
mrgramm is on a distinguished road
Default
Use advanced filter to filter to a new sheet.
Reply With Quote
Reply

Tags
conditional formatting, due date, reports

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
create a report karkey Word VBA 0 01-03-2021 08:51 PM
Create report for when a date is 3 years old Formula indicating employees entitled to a salary increase every three years from date of appointmen Marcia Excel 4 08-13-2018 03:33 PM
Create report for when a date is 3 years old Nested If Statements in Formula Field to Produce the Diffrnc in Years Between Today's & Entered Date mshu31 Word 1 02-09-2017 02:04 PM
Date range mysteriously adding 4 years akatz85 Excel 7 03-25-2014 12:36 PM
Create report for when a date is 3 years old Using Field Codes to Calculate 5 years from a Date vandy Word 1 09-23-2009 11:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:21 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft