Hello

I've just downloaded a Time Card file from the Filemaker Pro website which is almost perfect for my needs! However, I'd like people to be able to use the full-stop or period when they enter times as it's handily on the number pad. I changed the format for the time fields so that . was the seperator not : but it doesn't work. It thinks I mean 9.3 seconds not 9.30am.

Anyone got a solution?

Thanks

ok

in layout mode: Format--> Time --> Format as: hhmm Symbol . 12 hour notation " am" trailing

That is all !!

Sorry, guess I didn't make myself clear in my initial post. I've already changed the field time settings so that the seperator is . not :

I've just tried it again in a test file (attached) and it still thinks the 9.30 is 9.3 seconds after midnight. Odd.

Thanks

testtimefile.zip

This is what happens when you double post. The answer was give in the other post.

http://www.fmforums.com/threads/showflat...true#Post163816

Lee

Apologies. Newbie and all that, not quite got my head around posting and remembering to mark the post as a favourite. COuldn't find the original post when I wanted to.

Thanks

Nicole

To see all of your posts, go to the Menu bar next to the word [color:"blue"] Search, and click on All Posts w/Previews select either [color:"blue"] My Posts or [color:"blue"] My Posts w/Preview and then click [color:"red"] Go .

HTH

Lee