Solved

FM - auto enter 4-digit year date Filemaker

Posted on 2011-09-14
2
445 Views
Last Modified: 2012-05-12
How can you auto-fix a 2-digit year to a 4-digit year automatically like you can auto-format phone numbers so you can skip the validation warning?  Looked into EE but only saw how to do it for MS Access.  And, I don't want to just format it to a 4-digit date via the Inspector, but need the date to have a 4-digit date.

0
Comment
Question by:rvfowler2
2 Comments
 
LVL 24

Accepted Solution

by:
Will Loving earned 500 total points
ID: 36538548
Well, you would only want to do this if you were sure that all dates were in the current century. For instance if you were entering birth dates for ancestors or the date a house was built, or a deed signed, 3/15/15 could be 1815, 1915 or 2015.

Generally speaking, if you enter a date with a two-digit year, FM will automatically assume that if its in the next 30 years that its in the current century and if it's more than 30 years, it's in the previous one. To quote FileMaker's KB:

FileMaker Pro converts two-digit year dates into four-digit year dates based on the year in which the date is entered, always assuming that the four-digit year date should be in either the next 30 years, or the preceding 70 years. The following table shows how two-digit year dates entered in three different years will convert to four-digit years.

FileMaker will also supply the current year automatically, if you enter only the month and day. For example, if I enter 9/14 for today, FM assumes that that is 9/14/2011. If I enter 9/14/11, it also assumes that it is 9/14/2011. If you talking about cleaning up existing dates, then you should be looking at performing a Replace operation on the affected fields.

For more details, see this FileMaker Knowledgebase article:

http://www.filemaker.com/11help/html/add_view_data.4.21.html
0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 36560570
thanks, that helps.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PDF In Filemaker GO 3 1,065
Filemaker record reorder popup 2 399
FM - Sorting Titles 5 68
Filemaker Server as a Web Portal - Licensing 3 138
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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

895 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

14 Experts available now in Live!

Get 1:1 Help Now