DateAdd Question

[DoneganF]

I'm using the follow expression as a query criteria to return the current fiscal year (July-June) value in the following text format; "FY 2020";

"FY " & Format(DateAdd("m",6,[Enter Date]),"yyyy")

I now need to return the value for the prior fiscal year. So I thought I could wrap the above expression in another DateAdd with a 'year - 1' .... but I can't seem to make it work.

Any help is always greatly appreciated!!

 

[theDBguy]

Hi. Have you tried?

"FY " & Format(DateAdd("m",6,DateAdd("yyyy",-1,[Enter Date])),"yyyy")

 

[DoneganF]

Thanks DBguy - exactly what I needed. Now that I see this expression I feel pretty dumb - I should have been able to work this one out. I guess I was just over-complicating things by thinking I need one DateAdd nessted into another DateAdd.

Again - your assistance is so, so VALUABLE, and I am very GREATFUL!

 

[theDBguy]

Thanks DBguy - exactly what I needed. Now that I see this expression I feel pretty dumb - I should have been able to work this one out. I guess I was just over-complicating things by thinking I need one DateAdd nessted into another DateAdd.

Again - your assistance is so, so VALUABLE, and I am very GREATFUL!

Hi. Glad to hear you got it to work. Good luck with your project.