Brian Dunning's FileMaker Custom Functions

DateRangeVal ( LowDate ; HighDate )

Date Range Validation

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

Alex Babkov   Alex Babkov
Real Evolution
http://www.realevolution.com.au

Share on Facebook Share on Twitter

  Sample input:
DateRangeVal( "15/10/07" ; "17/10/06" )
  Sample output:
0

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

Checks that datefields are valid first then checks that High date is actually higher than Low Date.

I made this because i let my users report over a date range. So i present a custom dialog and use this as a pre-script sort of thing.

Edit: I posted this CF ages and ages ago, and the 20 lines of code didn't really seem to do much. Anyway, I suppose it's still useful for validating text based date input.

 

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.

Under construction. Email me your wish list for improvements.