i am inserting a date from my form into my database (enterprise manager).
it is in the form:
i gave the field a datatype of smalldatetime.
i am calling it to a page, and it returns as:
I am trying to format it so that it is in this form:
Friday, July 22, 2005
I have a similar thing on my page, i use the same function:
and it works fine, but not for the july date.
The July date doesn't have a time associated with it (the 07/22/2005 comes from a calendar popup).
How can I format 07/22/2005 so that it appears as Friday, July 22, 2005 ?
The FormatDateTime function will work for dates aswell as times.
If IsDate(yourDate) Then
dteYourDate = FormatDateTime(yourDateHere, 1)
dteYourDate = FormatDateTime(Date, 1)
Originally Posted by buntine
i realize that the problem i am having has to do when the database returns a null for date.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)