Skip to main content
Participant
January 22, 2007
Question

EndDate

  • January 22, 2007
  • 1 reply
  • 377 views
Our current function is ... EndDate() >= Date() ... which is used to screen out any results prior to today's date.
We would like to modify this so that instead of today's date we would use the date 2 months prior to today's date, so that, for example the EndDate() on 1/22/07 would be 11/22/06.
Would appreciate help on the format for this.
Thanks in advance!
Rick
This topic has been closed for replies.

1 reply

Inspiring
January 23, 2007
You use a DateAdd function to get this, something like

DateAdd("m",-2,EndDate()) >= Date()

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"Tiggerick" <webforumsuser@macromedia.com> wrote in message
news:ep2nej$oar$1@forums.macromedia.com...
> Our current function is ... EndDate() >= Date() ... which is used to
> screen out
> any results prior to today's date.
> We would like to modify this so that instead of today's date we would use
> the
> date 2 months prior to today's date, so that, for example the EndDate() on
> 1/22/07 would be 11/22/06.
> Would appreciate help on the format for this.
> Thanks in advance!
> Rick
>