Professional Web Applications Themes

Date/Time field default values! - Coldfusion - Advanced Techniques

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 CreateODBCdate to insert them and DateFormat to display them properly (mmmm dd, yyyy) / edit them. What can I enter as a default value in a date field so that the USER doesnt need to fill in dates that he is unable to have at this point in time. because if DATE/TIME fields are left blank as it is.... then an error will be generated What default value can I plug into a date/time ...

  1. #1

    Default 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 CreateODBCdate to
    insert them and DateFormat to display them properly (mmmm dd, yyyy) / edit them.

    What can I enter as a default value in a date field so that the USER doesnt
    need to fill in dates that he is unable to have at this point in time.

    because if DATE/TIME fields are left blank as it is.... then an error will be
    generated

    What default value can I plug into a date/time field that will return little
    or nothing.... indicating the field is empty of an ACTUAL date entered by the
    user.

    Any help would be great
    -thanks!

    RayBan12 Guest

  2. #2

    Default Re: Date/Time field default values!

    Answered in other forum where you posted.
    CFDEBUG Guest

Similar Threads

  1. Get current date/time? Use them in hidden field?
    By EvolvedDSM in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: May 10th, 07:10 AM
  2. Insert ODBC Date time values
    By TheToe in forum Coldfusion Database Access
    Replies: 0
    Last Post: December 12th, 10:08 PM
  3. date & time in form field
    By dthatsme in forum Coldfusion - Getting Started
    Replies: 4
    Last Post: March 11th, 06:18 AM
  4. Separated date and time or one datetime field
    By Krzysztof Piotrowski in forum PHP Development
    Replies: 0
    Last Post: April 24th, 07:12 PM
  5. Replies: 1
    Last Post: December 18th, 11:23 AM

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
  •  

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