Add year to Date and return changed date field as a result

[mje_1964]

Hi- I am new to the forum and relatively new to Access.

I have taken a few Access courses and am trying to finish up my 1st major Access project. I am stuck on one thing and am hoping for a little bit of guidance.

I saw alot of posts about dates, but none that dealt with what I want to try to do.

I have a date that a survey was completed in my final report. I want to show this date on the report, but if it has been more than 1 year since the date I want the date to be highlighted so our consultants know they need to make a new visit to the customer.

I think I need to use something like:

([DATE]+365>Date(),

But after this, I get stuck at what I need to do next.

I'm hoping someone will be gracious enough to assist me.

Thanks in advance for any advice you have to offer.

 

[Phildaburn]

If you're doing this in an Access Report, select the control for [DATE] on the report, then use Conditional Formatting. Under "Condition 1" change it to "Expression is", then in the space next to that, insert [DATE]+365>Date(). Just below, you have all kinds of easy-to-use formatting tools to change the appearance of your [DATE] and its background.

Hope this helps...
Phil.

 

[Phildaburn]

Actually, use < rather than > to format the correct dates.

 

[mje_1964]

Phil-

Thanks- I guess I was thinking I was going to write this into the query- writing it into the report makes all the sense in the world. Not sure why I didn't think of that.

In case anyone else tries to do something similar- there was one flaw in my original thinking: the formula will need to read: [DATE]+365<Date() If you choose to have it be > than today's date, everything meets the condition.

Again- thanks for steering me in the right direction. One of the things about being a newbie is that I have an idea of what I want to do- I just don't always know where to do it!

 

[mje_1964]

I see we both figured that out!

 

[boblarson]

Just a suggestion but I would not use Date()+365. I would use DateAdd("yyyy", 1, Date()) as that will also take into account leap years.

 

[mje_1964]

Thanks- I completely forgot about leap years. I appreciate your suggestion.