SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Sep 2005
    Posts
    137
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ASP forms problem

    I want to acees a text field in a form from an ASP button but want the date to be diplayed in the format '12-dec-05'... Can any one plz help...

    vv=cdate(request.querystring("btn"))
    Response.Write("Hello " & vv & "!<br />")


    Set objRs = objConn.Execute("SELECT DISPATCH_DETAILS.COMMODITY_CODE, Sum(DISPATCH_DETAILS.QUANTITY_NET) AS SumOfQUANTITY_NET, Sum(DISPATCH_DETAILS.QUANTITY_GROSS) AS SumOfQUANTITY_GROSS FROM DISPATCH_DETAILS INNER JOIN DISPATCH_MASTERS ON DISPATCH_DETAILS.CODE = DISPATCH_MASTERS.CODE WHERE (((trunc(DISPATCH_MASTERS.DISPATCH_DATE))='vv')) GROUP BY DISPATCH_DETAILS.COMMODITY_CODE")
    Response.Write "<table border=1 cellpadding=4>"
    Response.Write "<tr>"

  2. #2
    SitePoint Enthusiast
    Join Date
    Nov 2006
    Posts
    28
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    have you tried "formatdatetime" ?
    *** NEW ***
    A new technology site has launched...
    COMPUTERHELPCENTRAL.COM is GROWING FAST, join us now!!
    Don't miss out, be part of the central.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •