Brian Dunning's FileMaker Custom Functions

FastDateInput ( input ; format )

Allows user to input a date faster

  Average rating: 4.5 (32 votes) Log in to vote

Fabrice Nordmann   Fabrice Nordmann - Show more from this author
1-more-thing
https://www.1-more-thing.com

Share on Facebook Share on Twitter

  Sample input:
FastDateInput ("105 ; "USA" )
  Sample output:
10/5/2006

  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 ) :
http://www.briandunning.com/cf/373

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)
- 12/07/1998
- 12/7/98
- 120798
- 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

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth:

Under construction. Email me your wish list for improvements.