FastDateInput ( input ; format )
Allows user to input a date faster
Average rating: 4.5 (32 votes) Log in to vote
Fabrice Nordmann - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
I realise just before posting that an almost similar function was published by Solar system wide acclaimed developer Daniele Raybaudi ;)
FormatAsDate ( text ) :
so you have now even more choice.
a demo file can be downloaded here : http://fabrice.nordmann.free.fr/customfunctions/FastDateInput.zip
the purpose of this function is to allow user to input dates faster
so please note that it’s name is extremely relevant ;-)
it handles the date format wether you are using international format (dd/mm/yyyy) or
American format (mm/dd/yyyy). Format must be set to 1 or “USA” to use American format.
User can now type : (let’s say system format is set to international)
- 12078 : this returns 12/07/2008
- 1207 : this returns 12/07/2006 (2006 being current year)
- 12 : returns 12/07/2006 (07/2006 being current month)
- toto : this is an error and will be colored
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.