DateRangeVal ( LowDate ; HighDate )

Date Range Validation

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

Alex Babkov - Show more from this author
Real Evolution
www.realevolution.com.au

Sample input:

DateRangeVal( "15/10/07" ; "17/10/06" )

Sample output:

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

Let([
lowDate = GetAsDate(LowDate) ;
highDate = GetAsDate(HighDate) ];

IsValid(LowDate) and IsValid(HighDate)
and LowDate <  HighDate

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

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

DateRangeVal ( LowDate ; HighDate )

Comments

Support this website.

Support this website.