Access Date field?

Report · Sep 23, 2008

I need to test the value of a Date field in an Access database. Can I *not*
do it like this -

<% if (rsTestimonials.Fields.Item("quotes_date").Value) <> "12/25/2007" then
response.write(rsTestimonials.Fields.Item("quotes_date").Value) & "<br>"%>

For some reason this test is not working as I would expect.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================

Report · Sep 23, 2008

Nevermind - operator error!

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:gbb353$kaj$1@forums.macromedia.com...
>I need to test the value of a Date field in an Access database. Can I
>*not* do it like this -
>
> <% if (rsTestimonials.Fields.Item("quotes_date").Value) <> "12/25/2007"
> then response.write(rsTestimonials.Fields.Item("quotes_date").Value) &
> "<br>"%>
>
> For some reason this test is not working as I would expect.
>
> --
> Murray --- ICQ 71997575
> Adobe Community Expert
> (If you *MUST* email me, don't LAUGH when you do so!)
> ==================
> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
> ==================
>
>