<div>
As Scruv mentioned, you have to create two fields in FileMaker to store a date-stamp: DateStamp and TimeStamp. &nbsp;In the field definitions for the fields (File &gt;&nbsp;Define Fields) double click on the DateStamp field; then in the &quot;Auto-Enter&quot; tab of the resulting dialog box, select the first option (&quot;the Creation Date&quot;). &nbsp;You can change &quot;Creation Date&quot; to &quot;Modification Date&quot;. &nbsp;This will cause the field to be udpated with the current date every time the record is updated. &nbsp;Do the same for your TimeStamp field.<br />
<br />
If you want to retain your imported data you'll have to use the Replace command with a calculated result, then define a calc like: LeftWords(oldDateTimeStamp<wbr />, 3) to extract the date portion. &nbsp;Then do the same for the time. &nbsp;You might have to wrap textToDate( ) and textToTime( ) around the leftWords( ) and rightWords( ) calcs for this to work. &nbsp;Good luck,<br />
<br />
Mariano
</div>


As Scruv mentioned, you have to create two fields in FileMaker to store a date-stamp: DateStamp and TimeStamp.  In the field definitions for the fields (File > Define Fields) double click on the DateStamp field; then in the "Auto-Enter" tab of the resulting dialog box, select the first option ("the Creation Date").  You can change "Creation Date" to "Modification Date".  This will cause the field to be udpated with the current date every time the record is updated.  Do the same for your TimeStamp field.

If you want to retain your imported data you'll have to use the Replace command with a calculated result, then define a calc like: LeftWords(oldDateTimeStamp, 3) to extract the date portion.  Then do the same for the time.  You might have to wrap textToDate( ) and textToTime( ) around the leftWords( ) and rightWords( ) calcs for this to work.  Good luck,

Mariano

<div>
<div class="content wysiwyg-content">
i have a Date field that i've imported and it looks like this:<br />
<br />
11/19/2003 16:10:07<br />
<br />
if the field is called &quot;Date&quot;<br />
how do i define it &nbsp;- i want it to be mm/dd/yyyy and Now() so a timestamp when someone enters a new field in a db.
</div>
</div>


i have a Date field that i've imported and it looks like this:

11/19/2003 16:10:07

if the field is called "Date"
how do i define it  - i want it to be mm/dd/yyyy and Now() so a timestamp when someone enters a new field in a db.

define date field

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.