I need to Hide the default dates SQL Server shows on the Confirm page.
If a Date Time is not entered, SQL Server automatically fills in the space with the default date of 1900.01.01 00:00 (I have converted the date/time to a quasi military).
I do not want this date to show when the recordset is used.
I have tried the Tutorial in Macromedia:
but it is in JavaScript and I can't get it to work.
I have tried this script and it works:
<%
If rsNull.Fields.Item("DiaryDate".Value <> "1900.01.01" Then
Response.Write(rsNull.Fields.Item("DiaryDate".Value)
Else
Response.write(""
End If
%>
but I would like to make a Reusable Server Behavior from this as there are multiple instances of this over multiple pages!!!!
Is it possible and if so, can I use it more than once on a page?
Thanks,
Brenda
If a Date Time is not entered, SQL Server automatically fills in the space with the default date of 1900.01.01 00:00 (I have converted the date/time to a quasi military).
I do not want this date to show when the recordset is used.
I have tried the Tutorial in Macromedia:
but it is in JavaScript and I can't get it to work.
I have tried this script and it works:
<%
If rsNull.Fields.Item("DiaryDate".Value <> "1900.01.01" Then
Response.Write(rsNull.Fields.Item("DiaryDate".Value)
Else
Response.write(""
End If
%>
but I would like to make a Reusable Server Behavior from this as there are multiple instances of this over multiple pages!!!!
Is it possible and if so, can I use it more than once on a page?
Thanks,
Brenda