Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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: 587
Logit is a jewel in the roughLogit 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: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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,923
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

There are also easy Power Query possibilities. If you post a sample sheet ( no pics please) we can work on it
__________________
Using O365 v2503 - 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: 948
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



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 04:31 PM.


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