Search Range for the Previous Month
Average rating: 4.3 (38 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This function is handy for populating a date field in Find mode with the range of Last Month.
|David Head, uLearnIT
Aug 13, 2009
|Is this more readable and structured?
thismonth = Month ( Get ( CurrentDate ) );
thisyear = Year ( Get ( CurrentDate ) );
startdate = Date ( thismonth - 1; 1; thisyear );
enddate = Date ( thismonth; 0; thisyear )
startdate & "..." & enddate
|Lee, Brisbane , QLD
Aug 16, 2009
|Yes , that makes more sense than my version. Many thanks.|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.