define date field

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.
phillystyle123Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ScurvCommented:
Date and Time are different variables in FMP. This should give you want you want:

DateToText(Status(CurrentDate)) & " " & TimeToText(Status(CurrentTime))

It will automatically be formatted to your computers regional settings (e.g. American, English). If you want to change how it looks then you need to do some clever month, day, year extractions and then recompile in the correct order.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mariano_PetersonCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.