JavaScript / Google Apps Scripting - Write function to calc dates
$5-10 USD
Annulleret
Slået op over 11 år siden
$5-10 USD
Betales ved levering
Write a function for Google Apps Scripting to run in a Google Drive spreadsheet. Function takes input of birth date and calculates if a person is young enough to be eligible, using two rules. I think the comments below explain, but send me any questions. Write functions to accept DOB as y,m,d integers and another to accept one input of date data type
** Google Apps Scripting - function will be copy paste into an existing Google Apps Spreadsheet script with other functions.
Deliverable is the code I can cut paste into my scripts for the sheet.
function exrAgeEligibleInputInts(intBirthYear,intBirthMonth,intBirthDay,bolPerformed){
// Age eligibility calculator using input Date of Birth as ints for year, month, day
// Season is June 1 to Aug 15. Function calculates for 2014 season
// No musician over the age of 21 may participate in a performance.
// exception:
// A musician that participates in at least one performance during the season while age 21 and turns 22 during the season my complete the season.
//Returns one of three strings
// "Eligible
// "Eligible by exception
// "Not eligible
}
function exrAgeEligibleInputDate(dtDateOfBirth,bolPerformed){
// (same as above) using one input param of DOB as date type
}