Auto Adjust year if the year is greater than current year

[chadski021]

I have a date field when i type 6/8/40 it becomes 6/8/2040 is there a fix this instead of 2040 it should be 1940

[Lee Smith]

You have to use the 4 digit year for those years prior to 2000.

 

Do a Google search for YK2 and you will see why.

 

Lee

[comment]

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.

[chadski021]

Thanks it works