>Okay, a quick one - is 12:00 midnight "00:00" in military time or is it "24:00" (you can tell I have never been in the military)? Likewise, is the range of acceptable values "00:01" to "24:00" or "00:00" to "23:59"? And finally, is it possible that both 00:00 and 24:00 are acceptable values?
>
>Albert
Albert,
AFAIK it's 24 hour format w/o colons. 0000 = 2400 interchangebly (but I think they'd prefer to reserve 0000 for an operation's start time?).
From VFP point it looks like military time is :
substr(ttoc(ltDatetime,1),9,4)
or:
int(val(substr(ttoc(ltDatetime,1),9,4)))
Cetin