I have a time stamp that reads 15:28:02, I need to pass this to another system as 152802. I'm can't hit upon the right query expression as I keep getting 3282. The military hour converts back to the standard hour and the zero in the minutes and seconds seem to disappear. Not sure what to try next.
Any suggestions will be appreciated, thanks.
Thanks for the help.
Greg
Any suggestions will be appreciated, thanks.
Thanks for the help.
Greg