Brian Dunning's FileMaker Custom Functions

TextToDateRangeƒ ( text )

A rewrite of MagicDates by Andy Frazier with less code

  Average rating: 4.1 (41 votes) Log in to vote

Michael Rhodes   Michael Rhodes
Allied Data Service
http://allieddataservice.com

Share on Facebook Share on Twitter

  Sample input:
TextToDateRangeƒ ( "Next Quarter" )
  Sample output:
"4/1/2009...7/31/2009"

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

See custom function MagicDates

 

Comments

Shai Ben Mordechai   Shai Ben Mordechai, Tel Aviv
Apr 3, 2009
How do you convert the date range from American to European date format ?
 
Lee Smith   Lee Smith
Apr 5, 2009
Your quarters are not quarters.

Second quarter is 4/1/2009 to 6/30/2009

Lee
 
Michael Rhodes   Michael Rhodes, Rancho Cucamonga
Apr 13, 2009
Lee,

"Second quarter" is not an option. Read the notes in the function. However, "This quarter" or "Last quarter" or "Next quarter" work just fine. The first three hours this was posted, there was a typo, so recopy the code if necessary.
 
Michael Rhodes   Michael Rhodes, Rancho Cucamonga
Apr 13, 2009
Shai,

I do not own a European version of FileMaker, so I can't test how FileMaker might use different parameters for it's date function.
 
Shai Ben Mordechai   Shai Ben Mordechai, Tel Aviv
Apr 18, 2009
Michael,
You don't need to have a European version of FM. The date format belong to the "Regional and Language Options" in the control panel of the computer. In my case the date format is DD/MM/YYYY

TIA
Shai
 

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 20 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: