How can retrieve date format yyyy/mm/dd format in ASP ?

Date save in sql server yyyy/mm/dd format when I retrieve date in asp ie. strdate

asp page retrieve date format mm/dd/yyyy why ?

at the time of data entry, in same format date save and
same format date retrieve in asp page?


<TR>
    <TD>Start Date (yyyy/mm/dd)</TD>
    <TD><%Response.Write("<INPUT id=strdate name=strdate value='" & rs("strdate") &"'>")%></TD></TR>
  <TR>


Regards.

Mateen

Mateen,

You can use it this way.

Replace the within the INPUT tag, with the code given above.

Cheers,

-Vijay G

Thanks Vijay G

There is problem in day/month/year format

I use your code like this

fieldData = Day(rs("appstrdate")) & "/" & Month(rs("appstrdate")) & "/" & Year(rs("appstrdate")) & ""
If Len(fieldData) = 0 Then fieldData = " - "
Response.Write("<td align=center>" & fieldData & "</td>")


When date is null it displaying // in the date column why ?

when date is null it should be displayed - in the date column ?

How can display date format if date is null it display - in the date column ?

Regards.

Mateen

Mateen,

You should check if the date column is null once you retrieve it from the database (using the recordset object). Thats is the right approach, instead of formatting it into "fieldData" and then checking if that is null. I am not sure what you would want to display when the date column returns null. So you can decide on it and act accordingly.

Cheers,



-Vijay G

thanks for response.

I was want that when date column returns null it display " - "
otherwise display date.

now I use your code like this.

fieldData = Day(rs("appstrdate")) & "/" & Month(rs("appstrdate")) & "/" & Year(rs("appstrdate")) & ""
If fieldData = "//" Then fieldData = "-"
Response.Write("<td align=center>" & fieldData & "</td>")

in the date columne date will enter, if date is null then it will
display " - "

now it is solve the problem.

Mateen

Dear Vijay G

sorry for again.

how can use year/month/day format at the time of update the date
field. when date is null it display // why ?

ssql="strdate from contracts where contractno='"& contractno &"'"

set rs=cn.Execute(ssql)

<TR>
    <TD>Start Date (y/m/d)</TD>
<TD><%Response.Write("<INPUT ID=strdate name=strdate value='" & Year(rs("strdate")) & "/" & Month(rs("strdate")) & "/" & Day(rs("strdate")) & "'>")%></td></tr>


I controll this when date have to display (previous coding). when date to update (edit) how can solve this.

it should not display // at the update date field ?

OR

How can check at the time of retrieve the date from the database
(using the recordset object),
if date if null it display null otherwise display date ?

Regards.

Mateen

That is because you first formatted the date and then trying to check if it is null. The same I have stated in my previous mail. You could check that this way.

<%
ssql="Select strdate from contracts where contractno='"& contractno &"'"

set rs=cn.Execute(ssql)
if not rs.EOF then
    If len(rs(DATEFIELD))>0 then
%>
        <TR>
            <TD>Start Date (y/m/d)</TD>
             <TD><%Response.Write("<INPUT ID=strdate name=strdate value='" & Year(rs("strdate")) & "/" & Month(rs("strdate")) & "/" & Day(rs("strdate")) & "'>")%></td></tr>

     <%else %>
        <TR>
        <TD>Start Date (y/m/d)</TD>
            <TD><%Response.Write("<INPUT ID=strdate name=strdate value=''>")%></td></tr>
<%
    end if
end if
%>

Hope this helps.

Cheers,

-Vijay G

thanks a lot

Mateen