Date end of month 13 months ago

[jz3b2q]

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 criteria for the field is:

NewValue: IIf([INTRO_DATE]>#31/01/2012#,[StckValue],0)

I would appreciate any ideas for me to try

Thanks in advance.

 

[pwbrown]

This should do the trick:
DateAdd ("m", -13, TestDate)

 

[jz3b2q]

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.

 

[jz3b2q]

Thanks yes that worked a treat!