2. ASPRunnerPro General questions
  3. Military time format
This topic is locked

Military time format

 		7/4/2008 2:15:18 PM
ASPRunnerPro General questions
D
 dunga author

Hello, i have a field which stores the course time as a military time format:

the field is preformated in access as MEMO, i also tried as TEXT, variety types of DATE/TIME.
for example 1300-1600

what ever combination I have used Log date, medium date, short date did not give me correct display of time.
Is there a way to display the military formatted time using the date/time options in ASP runner?
jfr 7/5/2008

Hi,
Try putting this into the Column instead of your Datefield.
SELECT CONVERT(CHAR(10),GETDATE(),108)
This should do the trick.
John