Marcus, agrade�o pela aten��o.
 
    Mas estou querendo trazer na Query.
 
 
strQuery = "SELECT * FROM deposito_rjo WHERE datadeposito ='"& id & "' Order By autonum desc"
strQuery2 = "SELECT DISTINCT datadeposito FROM deposito_rjo"
 
<form name="form1" method="post" action="">
          <select name="datadeposito" size="1" >
            <%While Not objRS2.EOF %>
            <option value="<%Response.write objRS2("datadeposito")%>"><%Response.write objRS2("datadeposito")%></option>
                        <%
        'Movendo para o proximo registro
        objRS2.MoveNext
        Wend
        'Fechando as conex�es
        objRs2.close
'        objConn.close
        Set objRs2 = Nothing
        'Set objConn = Nothing
        %>
          </select>
          <input type="submit" name="Submit" value="Filtrar">
        </form>
----- Original Message -----
From: Marcus
Sent: Friday, September 19, 2003 12:44 PM
Subject: [Asp10.net] Re: Re: Formatar Data

Fala Luis ,
 
tenta assim :
 

Format(CType(seucampo.Text, Date), "yyyy-MM-dd")

 

 

[ ] 's

 

Marcus

 

----- Original Message -----
From: Luis
Sent: Friday, September 19, 2003 12:16 PM
Subject: [Asp10.net] Re: Formatar Data

format
----- Original Message -----
Sent: Friday, September 19, 2003 11:33 AM
Subject: [Asp10.net] Formatar Data

    Bom Dia,
 
    Tenho em banco db campo data/hora, como posso trazer o resultado em formato AAAA/MM/DD
 

:: http://www.asp10.net
==================================================
:: Solu��es simples para problemas complexos
:: Sistemas de Links, Not�cias, Faq, Loja,
:: Estat�sticas, Artigos, Mural e muito mais.
==================================================
:: Para entrar, sair ou ver o hist�rico da lista
:: Asp10.net visite http://www.asp10.net
==================================================



cancelar assinatura - p�gina do grupo

Responder a