format time

[moleboy]

I'm trying to format txttime using

Cdate(Request.Form ("txtTime&quot)

the input into txtTime is '0800' but this returns 0 when formatted.

can any one help?

Moley

 

[shaddow]

Well the defaul date/time format Cdate expects it's usually mm/dd/yy h:m:s AM/PM or what date/time locale are you using

Do you want to store only Time? not the date to? you could use numeric fields for hours, mins, etc and not Date/Time fields

________
George, M

 

[moleboy]

I only want to store the time and discard all other info.

 

[shaddow]

Well i use 2 ways of dealing this
1. Date/Time fields
use same date for all times and store it to database
myTime="1/1/1900" & Mid(Request.Form ("txtTime&quot,1,2) & ":" & Mid(Request.Form ("txtTime&quot,3,4) & ":00"

2. Text field
myTime=Request.Form ("txtTime&quot

Both ways you can compare the time if the time is like your format (1256 or 2300)

________
George, M

 

[shaddow]

Oops i've made 1 error

Mid(Request.Form ("txtTime&quot,3,4) should be Mid(Request.Form ("txtTime&quot,3,2)

________
George, M

 

[moleboy]

Thanks, it working now.