Using a full-stop (period) as seperator,time field

[Nicnacs]

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

[Raybaudi]

ok

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

That is all !!

[Nicnacs]

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

[Lee Smith]

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

[Nicnacs]

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

[Lee Smith]

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