473,387 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

inputting date into form updating database

Hi everyone

I am trying to create a form to update a database table. I have all the
fields, set up, and a submit button happily processes my form.
However, I am trying to create a field in my table, that will store a date.
The date and time the form was submitted.

So i created a date/time field in my DB and added a now() function to it.
Is it possible to put some kind of html in my form now to, when posted,
carry a hidden field to my DB. and if yes, what is the correct syntax for a
date input?

Is it something along this line

<input type="hidden" id ="hDate" name="hDate" value="">
I guess it's the value that's most important but i know not what to put
there.

Can someone help me?

Thanks

Raphael
Jul 19 '05 #1
2 2223
Raphael Gluck wrote:
...

So i created a date/time field in my DB and added a now() function to
it. Is it possible to put some kind of html in my form now to, when
posted, carry a hidden field to my DB. and if yes, what is the
correct syntax for a date input?


does your RDBMS support default values?

--
William Tasso - http://WilliamTasso.com
Jul 19 '05 #2
Yes, I am using access XP,
I created a date/time field, general format i.e
22/08/2003 14:38:29

in the default value i have entered now()

Now what must i do?

Thanks
Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: rp | last post by:
Hi, I have a form in which I do a number of checks using javascript to make sure the date is posted as DD/MM/YY. But when I then get the ASP side of running checks and updating data the date...
3
by: Andrew Poulos | last post by:
I'm updating a db in which I have a column of Date/Time data type. The regional settings here for short date are: day / month / full year eg. 28/4/2005 It's easy enough for me to build a string...
8
by: John Wildes | last post by:
Hello all I'm going to try and be brief with my question, please tell me if I have the wrong group. We are querying transaction data from a DB3 database application. The dates are stored as...
5
by: Chris | last post by:
I have a meetings section I'm developing on our intranet. Using PHP/MySQL. Meeting info and Meeting docs reside on 2 related tables in the db. Users may want to upload anywhere from 1 to 10 or...
7
by: lmnorms1 | last post by:
Hello, I am trying to update an access database record date field that matches a specific date. The code is not working. Anyone have any advice? Here is the code: Dim gConnString As String =...
0
by: oneplace | last post by:
I have the following script that use for the following after i have made my search for a name in my database. I select the name and it bring up this from with all the information of the person. It...
1
by: EyeHawk | last post by:
OK, hopefully somebody can help me out again. My next problem is updating 3 form fields (type list/menu option) that correspond to a date, one for month, one for day and one for year when the user...
3
by: Tony K | last post by:
Does anyone know why my 2 date fields on my form that are bound to date fields in the Access DB do not save unless I first modify the dates? Example: When I add a new record, the following line of...
9
by: jerry101 | last post by:
I am currently using a version of phpmyadmin via heartinternet. I can connect to my database fine, but I cannot seem to input any database into the table I have created. the database is called...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.