The problem is with the following codes:
my ($mon, $day, $year, $time, $ampm) = split(/ /, $date);
my ($hour, $min, $sec) = split(/:/, $time);
You are splitting values twice, which I believe is the source of your problem.
Here are some suggestions:
1) Use the default sub get_date codes for printing the date in the database. Then use a conversion sub-routine to print the date and time in your web pages.
2) Use a hidden field in your sub html_record_form routine like the following:
<input type="hidden" name="Time" value="$rec{'Time'}">
BTW: You do NOT need single quotation marks for field names that contain only one word. Single quotation marks are only used for field names with more than one word.
Example:
Read_FAQ
OR
'Visit Resource Center'
Regards,
Eliot
Code:
my ($mon, $day, $year, $time, $ampm) = split(/ /, $date);
my ($hour, $min, $sec) = split(/:/, $time);
You are splitting values twice, which I believe is the source of your problem.
Here are some suggestions:
1) Use the default sub get_date codes for printing the date in the database. Then use a conversion sub-routine to print the date and time in your web pages.
2) Use a hidden field in your sub html_record_form routine like the following:
Code:
<input type="hidden" name="Time" value="$rec{'Time'}">
BTW: You do NOT need single quotation marks for field names that contain only one word. Single quotation marks are only used for field names with more than one word.
Example:
Code:
Read_FAQ
OR
Code:
'Visit Resource Center'
Regards,
Eliot