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.

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: