Shopping Cart
FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.
|
||||||||||||||||||||||||||||||||||||||||
LastMthSearchRange Rate this function:   Discuss this Custom Function Lee Dolereit, Sharp ABT Search Range for the Previous Month
Description:This function is handy for populating a date field in Find mode with the range of Last Month. Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems. This is my Custom Function and I want to edit it Discuss:Yes , that makes more sense than my version. Many thanks. Lee, Brisbane , QLD Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post: |
|
|||||||||||||||||||||||||||||||||||||||
Is this more readable and structured?
Let ([
thismonth = Month ( Get ( CurrentDate ) );
thisyear = Year ( Get ( CurrentDate ) );
startdate = Date ( thismonth - 1; 1; thisyear );
enddate = Date ( thismonth; 0; thisyear )
];
startdate & "..." & enddate
)
David Head, Darwin Australia
August 13, 2009 12:40am