Search results

Thanks yes that worked a treat! :)

so would that be... DateAdd ("m", -13, TestDate) IIf([INTRO_DATE]>#(DateAdd ("m", -13, TestDate))#,[StckValue],0) Sorry.. not an expert at all in this. I have inherited it.

Hello, I hope you can help me. I am trying to compare a date with the end of month 13 months ago, currently i gjust go in every month and change it manually... Is there a way to automatically set it to always pick up the correct date. E.g. TestDate>(Date()-13months) currently the...