var result = ""; var i = ""; var rightNow = Now(); Do { i = dateDiff('yyyy',arguments.dateThen,rightNow); if ( i GTE 2 ) { result = "#i# years ago"; break; } else if ( i EQ 1 ) { result = "#i# year ago"; break; } i = dateDiff('m',arguments.dateThen,rightNow); if ( i GTE 2 ) { result = "#i# months ago"; break; } else if ( i EQ 1 ) { result = "#i# month ago"; break; } i = dateDiff('d',arguments.dateThen,rightNow); if ( i GTE 2 ) { result = "#i# days ago"; break; } else if ( i EQ 1 ) { result = "#i# day ago"; break; } i = dateDiff('h',arguments.dateThen,rightNow); if ( i GTE 2 ) { result = "#i# hours ago"; break; } else if ( i EQ 1 ) { result = "#i# hour ago"; break; } i = dateDiff('n',arguments.dateThen,rightNow); if ( i GTE 2 ) { result = "#i# minutes ago"; break; } else if ( i EQ 1 ) { result = "#i# minute ago"; break; } i = dateDiff('s',arguments.dateThen,rightNow); if ( i GTE 2 ) { result = "#i# seconds ago"; break; } else if ( i EQ 1 ) { result = "#i# second ago"; break;} else { result = "less than 1 second ago"; break; } } While (0 eq 0); return result; var retDate = ""; var y = arguments.inYear; var m = arguments.inMonth; var d = arguments.inDay; var yMin = 1900; // This value can be any valid year greater than 1900 var mMax = 12; var dMax = 31; // Validate inYear entry if ( y LT yMin ) y = yMin; // Validate inMonth entry if ( m GT 12 ) m = 12; else if ( m LT 1 ) m = 1; // Validate inDay entry dMax = DaysInMonth(CreateDate(y,m,1)); if ( d GT dMax ) d = dMax; else if ( d LT 1 ) d = 1; retDate = CreateDate(y,m,d); return retDate; return week(arguments.inDate) - week(createDate(year(arguments.inDate),month(arguments.inDate),1)) + 1; return DateFormat(arguments.inDate,"ddd"); return DateFormat(arguments.inDate,"mmm"); var retDate = firstDayOfWeek(arguments.inDate); var addType = "ww"; // week retDate = DateAdd(addType,arguments.addQty,retDate); return retDate; var addType = "m"; // month var retDate = firstOfMonth(Month(arguments.inDate),Year(arguments.inDate)); retDate = DateAdd(addType,arguments.addQty,retDate); return retDate; // Create Date Object from year,month and day entries var retDate = createValidDate(arguments.inYear,arguments.inMonth,arguments.inDay); // Check to see if the ordinalDay value passed in was first or last if ( arguments.ordinalDay EQ "first" ) { // set retDate as the First of the Month retDate = getNextXYearsFirstOfMonthDate(inDate=retDate,addQty=arguments.addQty); } else if ( arguments.ordinalDay EQ "last" ) { // set retDate as the Last of the Month retDate = getNextXYearsLastOfMonthDate(inDate=retDate,addQty=arguments.addQty); } return retDate; var addType = "yyyy"; // DateAdd year mask var retDate = DateAdd(addType,arguments.addQty,arguments.inDate); retDate = firstOfMonth(Month(retDate),Year(retDate)); return retDate; var addType = "yyyy"; // DateAdd year mask var retDate = DateAdd(addType,arguments.addQty,arguments.inDate); retDate = lastOfMonth(Month(retDate),Year(retDate)); return retDate; var dates = structNew(); var refDate = createDate(year(arguments.inDate), month(arguments.inDate), 1); // set the next and previous months dates.nextMonth = month(dateadd('M',1,refDate)); dates.nextYear = year(dateadd('Y',1,refDate)); // reset year if next month is january if( dates.nextMonth eq 1 ) dates.nextYear = dates.nextYear + 1; dates.lastMonth = month(dateadd('M',-1,refDate)); dates.lastYear = year(dateadd('Y',-1,refDate)); // check to make sure that next/last year is not more than 2 years away from refDate if( dates.nextYear gt year(dateAdd("yyyy", 2, refDate)) ) { dates.nextYear = year(dateAdd("yyyy", 2, refDate)); dates.nextMonth = month(refDate); } else if( dates.lastYear lt year(dateAdd("yyyy", -2, refDate)) ) { dates.lastYear = year(dateAdd("yyyy", -2, refDate)); dates.lastMonth = month(refDate); } return dates; var dates = structNew(); var firstOfThisWeek = application.ptCalendar.date.firstDayOfWeek(arguments.inDate); var lastOfThisWeek = dateAdd("d", 6, firstOfThisWeek); var firstOfLastWeek = dateAdd("d", -7, firstOfThisWeek); var firstOfNextWeek = dateAdd("d", 7, firstOfThisWeek); var formattedThisWeek = dateFormat(firstOfThisWeek, 'mmmm dd, yyyy'); var formattedLastWeek = dateFormat(firstOfLastWeek, 'mmmm dd, yyyy'); var formattedNextWeek = dateFormat(firstOfNextWeek, 'mmmm dd, yyyy'); // set the next and previous months dates["firstOfThisWeek"] = firstOfThisWeek; dates["lastOfThisWeek"] = lastOfThisWeek; dates["firstOfLastWeek"] = firstOfLastWeek; dates["firstOfNextWeek"] = firstOfNextWeek; dates["formattedThisWeek"] = formattedThisWeek; dates["formattedLastWeek"] = formattedLastWeek; dates["formattedNextWeek"] = formattedNextWeek; return dates;