Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

What am I doing wrong in making a format code HH:MM:SS.000?

In Base, I'm trying to get a field to have default formatting for CCTV time stamp as it appears on the camera, specifically HH:MM:SS.000

When I use HH:MM:SS.000 as the format code, it replaces the "000" bit with literally "000" when i move to the next line.

Example

I enter 01:24:30.731 into the appropriate box and when i move to the next entry, Base replaces what i've entered with 01:24:30.000

For now ive had to just enter the date as text (hh:mm:ss.xxx), but once ive understood how to make the correct code, will it automatically change that text into the appropriate format, or will i have to go through by hand?

Additionally, although possibly this may need to be covered in another separate question, I never seem to have much luck in understanding how to make the format codes and/or have them work as I expect. Specifically, I need a code to always display four digits, e.g. 0.900, 0.925, 0.800 etc., I also need to understand how to have letters displayed after numbers, but only from a selection of them e.g. Cu, Zn, Ag, etc. and so I can combine the two e.g. 0.900 Ag, 0.200 Cu etc..

I have tries and tried to go through existing documentation and understand how to do these things but either I'm being a little obtuse or......

Any help would be great thanks Regards

NB Why is the recaptcha thingy in Portuguese?