EventDate

I cant select the eventtext as my date in my datebase is of mm/dd/yyyy. I tried all ways of formatdatetime.Anyone who is kind enough to help me please with the select statement.How to convert the date to mm/dd/yyyy.

thisday=FormatDateTime(now(), 2)
rs.Open "select EventText from Events where EventDate = '"&thisday&"'", conn

View Replies


ADVERTISEMENT

ObjRS("eventdate").value

how to list a specific record's value on a one of many of these: <%=objRs("eventcaption")%>. I'll try to be as specific as possible but I am not sure if I know just how to describe it.Basically I have a calender and in each day I want to list an event caption such as "Wedding Day", specific to the events of any given day. Here is what I am looking at so far. Can I do something like <%=objRs("eventcaption.first")%>? Code:

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved