Is there a simple way to get date from a timestamp field in filemaker
8.5? It seems me really strange there are not inverted function from
timestamp (date; time) to get date and time...

You may want to look into the Help imbedded into FileMaker. A search with
that term then chosing 'Defining timestamp fields' gives you enough
information 1) to format the timestamp field and 2) to make the needed
calculations to extract the Date and the Time. Don't you think so ?

The reverse is also true, as you've got a 'Date' function and a 'Time'
fucnction, from which you could create a calculation field = Date (YrDate) &
" " & Time(YrTime).

Remi-Noel


"Aladino" <borgobello-NO (AT) SPAM-adriacom (DOT) it> a écrit dans le message de news:
1hnyv27.tkjixzkbqlkwN%borgobello-NO (AT) SPAM-adriacom (DOT) it...

The timestamp field can be treated exactly like a date field (or time field)
for calculation purposes. There is no need for any extra functions.

Day()
Month()
Year()

All work properly on both timestamp and date fields.

Furthermore, you can simply make your date field equal to the timestamp
field to extract the date.



"Aladino" <borgobello-NO (AT) SPAM-adriacom (DOT) it> wrote