G Guest Jul 18, 2005 #1 i need to print 12 midnight inmilitary time 2400 hours. i will not print out. i have to use 23;59pm
D Duane Hookom Jul 18, 2005 #2 You could try an expression that returns a string like: IIf([TimeField]=1,"24:00",Format([TimeField],"hh:nn"))
You could try an expression that returns a string like: IIf([TimeField]=1,"24:00",Format([TimeField],"hh:nn"))
M Marshall Barton Jul 18, 2005 #3 lasandrad said: i need to print 12 midnight inmilitary time 2400 hours. i will not print out. i have to use 23;59pm Click to expand... Midnight is 00:00 I suppose you could use some kind of expression to get 24:00 instead of 00:00. If you need help doing that, please post a description of your time field/variable/expression. Is it part of a date/time value?
lasandrad said: i need to print 12 midnight inmilitary time 2400 hours. i will not print out. i have to use 23;59pm Click to expand... Midnight is 00:00 I suppose you could use some kind of expression to get 24:00 instead of 00:00. If you need help doing that, please post a description of your time field/variable/expression. Is it part of a date/time value?
