I am trying to set up a CF app that would allow someone to put in the time and date of and event (with description) and have it show up on the intranet page. The form passes all the information through to MS Access correctly, and it all works--except for time. Entering the event time in Access gives a good result, but using the CF web form doesn't--all I get is 00:00 as an output. What is the correct procedure/syntax? Thanks for any advice.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Time Entry in forms problem
- Thread starter dwhitzig
- Start date
- Thread starter
- #2
Are you sure that works ?? That code will format the var 'Work" into, example, 04/25/99. Maybe this would work better...<br>
<br>
#TimeFormat(Now(), "HH:mm:ss")#<br>
<br>
Or maybe this is so long ago, 2 weeks, that you already have another solution.
<br>
#TimeFormat(Now(), "HH:mm:ss")#<br>
<br>
Or maybe this is so long ago, 2 weeks, that you already have another solution.
- Status
Similar threads
