Hi there,

I need to create a field for a call center database, where this field sould contain the Date & Time together, i.e., when I create a new record, this fiels is our Call Log number.

Ex.: the client call today 2005/02/02 at 15:03

I need that in the fiel appear this--> 200502021503

Is it possible?

Anyone can help me?

Thanks in advance.

Regards

JD

In FM7, the field type is time stamp.

In FM6, it would be a text calculation, DateToText (date) & " at " & TimeToText (time)

date and time would be date and time fields with auto-enter creation date and auto-enter creation time.

Year(datefield) & Right( "0" & Month(datefield), 2 ) & Right( "0" & Day(datefield), 2 ) & Right( "0" & Hour(timefield), 2 ) & Right( "0" & Minute(timefield), 2 )