Hi

Is it possible to format a timestamp field to only display the date part ??
When I try to edit in the field date format, I select Custom, but it alway
display the time with it...... I need time stamp field because when
importing data from SQL those are timestamp, but when display I want only to
show date......

And I don't want to setup a calc field with a formula to get the date from
the timestamp.

Thank you

JF

Have you tried formatting the time as custom also? Just set everything
to 'none'.

JF wrote:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

Time formatting doesn't provide for "none" in the same fashion as Date formatting. The time will always be there.

You'll need to create a calc:

YourTime = Time ( Hour ( TimeStamp ) ; Minute ( TimeStamp ) ; Seconds (
TimeStamp ) )

Matt

On 01/04/2007 21:55:11 "JF" <bizouman_takethisout (AT) hotmail (DOT) com> wrote:

Or, you could just size the field down so that the time doesn't have room to
appear.

"Matt Wills" <Im (AT) witz (DOT) end> wrote

That works, and more simply.

Matt

On 01/05/2007 05:45:40 "Bill Marriott" <wjm (AT) wjm (DOT) org> wrote:

"Matt Wills" <Im (AT) witz (DOT) end> wrote in message

Thank you but it doesn't work at all !! I use French version of software abd
when december or november is the month field have to be large, what about
May, I try that and it's not good.

Another easy thing that became complicated....

JF


"Matt Wills" <Im (AT) witz (DOT) end> a écrit dans le message de news:
15635.YLYDXQTD (AT) news (DOT) verizon.net...

The technique will work if you format the date as numbers only, or using the abbreviated month (Jan, Fev, Mar, Avr, etc.). Personally, I prefer the abbreviated month: uniform in length, little likelihood that whoever is looking at them doesn't know what they are, and one doesn't need to think about whether the first number is the day or the month.

Otherwise, as I mistakenly suggested earlier to derive the time, a calc field to give you just the date as contained in the timestamp:

YourDate = Date ( Month ( TimeStamp ) ; Day ( TimeStamp ) ; Year ( TimeStamp ) )

Alternately, a date field set with the current date by the same means as the timestamp is set. Script, auto-enter, whatever, just do it at the same time, and make sure neither can be changed later.

Matt

On 01/05/2007 15:46:25 "JF" <bizouman_takethisout (AT) hotmail (DOT) com> wrote:

You can enter up to eight characters into the last section of the custom
date format. That should give you plenty of padding to eliminate the time
from appearing in the field.

"Matt Wills" <Im (AT) witz (DOT) end> wrote