date & time in form field

Ask a Question related to Coldfusion - Getting Started, Design and Development.

  1. #1

    Default date & time in form field

    I want to put the current date and time into a form field which will them be
    submitted to a database. Is this possible? If so, what code should I use and
    how? If not, any suggestions would be helpful. Thanks!!

    dthatsme Guest

  2. Similar Questions and Discussions

    1. Get current date/time? Use them in hidden field?
      I've got an app that works as a reception log for clients coming in our agency. The receptionist logs each client's name into our log database. ...
    2. Syntax error when trying to update date/time field
      I am getting a MS Access ODBC Syntax error (missing operator) in query expression '2006-01-05 09:17:01.0' when I try to execute an update query. On...
    3. Date/Time field default values!
      I'm creating a CF page that keeps track of dates/time of things. I have all my Date/Time fields set-up as Date/Time in access and I use...
    4. date/time field from access 2000 db getting -1 in textbox on form
      I am stuck in using Access 2000 with on Windows 2000 server. I get a negitive 1 for a value. My code $DB_Conn = new...
    5. Separated date and time or one datetime field
      Hi all, I am learning php+mysql and am trying to set up a log database. I wonder if it is better to have 2 different columns for date and time...
  3. #2

    Default Re: date & time in form field

    It is possible: This will submit the current date and time, no formatting,
    once added in your datebase, you will need to use
    #DateFormat(myDate,'yyyy/mm/dd/')# and #TimeFormat(hh:mmtt)# to format your
    date like: 2005/03/09 12:12pm <input type='text' name='myDate' value='#Now#'>

    Latino Guest

  4. #3

    Default Re: date & time in form field

    Originally posted by: Latino
    you will need to use #DateFormat(myDate,'yyyy/mm/dd/')# and #TimeFormat(hh:mmtt)#

    Where do I put this?

    And won't I need to define #now# somewhere?

    dthatsme Guest

  5. #4

    Default Re: date & time in form field

    #now# is a system thing, you don't need to define it. Everytime your code excute it, it will return the current date and time to where ever you put it.

    Mike Yang Guest

  6. #5

    Default Re: date & time in form field

    My mistake:

    I meant #now()#

    [url]http://www.tecito.com[/url]
    Latino Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139