Data Manager - Trouble with time format
Author: gunn
Creation Date: 5/26/2009 2:13 AM
profile picture

gunn

#1
Hi

im trying to import an Ascii file whose time format is

20:00
00:00
04:00
08:00
12:00
16:00

etc....

none of the time formats that i can choose from seem to match and i cant import it, any ideas please ?

Thankyou

profile picture

Cone

#2
H:mm should work, but you can type in HH:mm if you like. The problem is more likely that you have to add a separate Time field and move it below the Date in the Field Order list.
profile picture

Eugene

#3
As Robert have just said, HH:mm is the way to go here:

Custom Date and Time Format Strings in MSDN

H represents the hour as a number from 0 through 23, while HH represents the hour as a number from 00 through 23.
profile picture

gunn

#4
Thankyou both for the reply, i have been able to add it now