0000 is valid value! For example time 0 hours 0 minutes and 15 seconds after calling Format("00:00:15","hhmm",currenttimef) will return "0000" : I have scripts that use the following commands to format the time value as : follows: Now(currenttime) : Format(currenttime,"hhmm",currenttimef) : The problem is that about 5% of the time I run the script the value in : CURRENTIMEF comes out as "0000" instead of the real time. The : other 95% of the time it works perfectly. Any clue what could cause this? : BTW, I've tried the macro command @T"hhmm" and it does not seem to : have this problem. I'm planning to change my scripts to use the macro : unless you can offer a cause/solution. Thanks!
|