Jump to content

Auto Adjust year if the year is greater than current year


This topic is 2632 days old. Please don't post here. Open a new topic instead.

Recommended Posts

When you enter a two-digit year, Filemaker has to guess the century - see here how this guess is made:

http://www.filemaker.com/help/12/fmp/html/add_view_data.4.21.html#1028976

 

If you want different results, you can use an auto-entered calculation to correct the entry, for example =

Case (
Year ( Self ) > Year ( Get ( CurrentDate ) ) ;
Date ( Month ( Self ) ; Day ( Self ) ; Year ( Self ) - 100 ) ;
Self )

However, this won't allow you to enter future-years dates at all, nor even explicitly.

Link to comment
Share on other sites

This topic is 2632 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.