Setting current date in specific field to match the date on the computer

Posted on 2011-05-08
Last Modified: 2012-05-11
I have a manufacture date for the product, and then a shipping date for when the product is shipped.  How can I have the shipping date match the date on the computer?  This would save time inputting the date each time we generate a report.
Question by:topgun0621
    LVL 24

    Accepted Solution

    Meaning you want the shipping date to be the current date when you create the record? Open your database to the screen where the date appears, then go to File -> Manage -> Database. This should show you the list of fields in the table that the layout is based on. You may only have one table or you may have many, but by default FileMaker always opens the Manage Database window to the table of the current layout.

    Once there find the shipping date field and click it to highlight it. In the lower right of your screen you'll see a button called "Options". In the Options dialog, click the checkbox for "Creation" and make sure "Date" is selected. Click OK, and the close the Manage Database dialog, saving changes if asked. Now the current date will be automatically entered in that field when the record is created.

    If instead you just want to have a way to enter the current date in a record that may or may not have been created today, there is both a menu command and keyboard shortcut for this. Click or tab into the field and then look under the "Insert" menu for "Current  Date". You can enter the date by selecting it from the menu or by using the keyboard shortcut which is Command-hyphen on the Mac and I believe, Control-hyphen on Windows. There are other more sophisticated ways to enter the date, time, calculated text, etc. but it depends hugely on the specific need.
    LVL 24

    Expert Comment

    by:Will Loving
    Options Dialog - Creation Date

    Author Closing Comment

    worked thanks alot adding another question

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now