Search Results
18 functions found:
| 1. | AddDays ( theDate; DaysToAdd ) |
| Andrew Sasaki | |
| Given a date and a number of days, returns the date that many days later. | |
| 2. | DaysDifference ( Date1 ; Date2 ) |
| Andrew Sasaki | |
| Returns the number of days difference in two dates; returns a negative number if the second date is earlier than the first. | |
| 3. | DaysDifferenceAbs ( Date1; Date2 ) |
| Andrew Sasaki | |
| Returns the number of days difference in two dates. | |
| 4. | getDomain ( theAddress ) |
| Andrew Sasaki | |
| parses the domain name from an email address or URL | |
| 5. | getSelectedText |
| Andrew Sasaki | |
| Returns the value of the currently selected text | |
| 6. | getTopLevelDomain ( theAddress ) |
| Andrew Sasaki | |
| Parses the top level domain from an email address or URL | |
| 7. | LastDayInstance ( theDate; NameOfDay ) |
| Andrew Sasaki | |
| Returns the last instance of a given day in the month of the date | |
| 8. | listFieldTypes ( listOfFields ) |
| Andrew Sasaki | |
| Returns a tab-delimited list of fields & field type info for every field on the current layout | |
| 9. | listRelationships ( listOfTables ) |
| Andrew Sasaki | |
| Generates a list of relationships from a list of tables for the current active file | |
| 10. | makeEmailAddress ( name1 ; name1CharacterLimit ; name2 ; name2CharacterLimit ; separator ; domain ) |
| Andrew Sasaki | |
| generates standardized email addresses | |
| 11. | MonthEndsOnDayName ( theDate ) |
| Andrew Sasaki | |
| Returns the name of the day of the week the month ends on. | |
| 12. | MonthEndsOnDayOfWeek ( theDate ) |
| Andrew Sasaki | |
| Returns the number of the day of the week the month ends on. | |
| 13. | MonthLength ( theDate ) |
| Andrew Sasaki | |
| Returns the number of days in the month of the date supplied. | |
| 14. | NextWeekday (theDate) |
| Andrew Sasaki | |
| Calculates the next weekday (Mon-Fri) of a given date | |
| 15. | NextWeekEndDay (theDate) |
| Andrew Sasaki | |
| Determines the next weekend day after a given date. | |
| 16. | PaddedText ( Source; FillChar; NumberOfChars ) |
| Andrew Sasaki | |
| Pads a text string to a specific number of characters using a fill character. | |
| 17. | SQL_DateTime_to_Date ( DateTime ) |
| Andrew Sasaki | |
| Converts SQL DateTime value to month/day/year date | |
| 18. | upcCheckDigit ( upcString ) |
| Andrew Sasaki | |
| Calculates UPC code check digit for any length UPC code. NOTE: Requires FMP 18 or later | |