I'm trying to display the time on my classic ASP page. When the data is NULL the code below displays the word "Sunday".
<%If IsNull(rs("SunIn")) or rs("SunIn")="" Then %>
The problem is that when the entry is updated the NULL becomes "1900-01-01 00:00:00.000" in the database.
I would still like the word "Sunday" displayed.
How could I change the code in order to achieve this? I tried
but it didn't help.
I would really appreciate your help.