var retVal = false; if ( IsDate(arguments.dateStr) AND (NOT IsNumeric(arguments.dateStr)) ) retVal = true; return UCASE(YesNoFormat(retVal)); var rtnStr = "am"; if( IsRealDate(arguments.dateTime) and timeFormat(arguments.dateTime, "HH") gte 12 ) rtnStr = "pm"; return rtnStr; var dow = ""; var dowMod = ""; var dowMult = ""; var firstDayOfWeek = ""; var date = trim(arguments.inDate); dow = dayOfWeek(date); dowMod = decrementValue(dow); dowMult = dowMod * -1; firstDayOfWeek = dateAdd("d", dowMult, date); return firstDayOfWeek; var returnDate = firstDayOfWeek(arguments.inDate); if( IsRealDate(returnDate) ) returnDate = dateAdd("d", 6, returnDate); return returnDate; var firstDayDate = ""; try { // create the first of the month as a date firstDayDate = createDate(arguments.inYear, arguments.inMonth, 1); // format it in CommonSpot terms firstDayDate = "#dateFormat(firstDayDate, 'yyyy-mm-dd')# 00:00:00"; } catch (any e) { ; } return firstDayDate; var lastDayDate = ""; var daysInThisMonth = ""; try { // how many days in this month daysInThisMonth = daysInMonth(createDate(arguments.inYear, arguments.inMonth, 1)); // create the last of the month lastDayDate = createDate(arguments.inYear, arguments.inMonth, daysInThisMonth); // format it in CommonSpot terms lastDayDate = "#dateFormat(lastDayDate, 'yyyy-mm-dd')# 23:59:59"; } catch (any e) { ; } return lastDayDate; var csDate = ""; if ( IsRealDate(arguments.dateInput) ) csDate = "#dateFormat(arguments.dateInput, 'yyyy-mm-dd')# #timeFormat(arguments.timeInput, 'HH:mm:ss')#"; return csDate; var theDate = createDate(arguments.theYear, 1, 1); return csDateFormat(theDate); var theDate = createDate(arguments.theYear, 12, 31); return csDateFormat(theDate); var tzStamp = ""; var tzData = GetTimeZoneInfo(); var tzHrOffset = 0; var tzMinOffset = 0; var tzOperator = "+"; // Use the hourOffset value, if one is passed in if ( LEN(TRIM(arguments.hourOffset)) AND IsNumeric(arguments.hourOffset) AND (arguments.hourOffset LTE 14 AND arguments.hourOffset GTE -(12)) ) tzHrOffset = arguments.hourOffset; else { // If hourOffset is not provided, use the GetTimeZoneInfo() values to ues Server's TimeZone information // - the CF utcHourOffset value is reverse from standard offset (utcHourOffset: 5 for -05:00) // - GetTimeZoneInfo() adjusts utcHourOffset for DST if ( StructKeyExists(tzData,"utcHourOffset") AND tzData.utcHourOffset GTE 0 ) tzHrOffset = -(tzData.utcHourOffset); else tzHrOffset = tzData.utcHourOffset; } // Use the minuteOffset value, if one is passed in if ( LEN(TRIM(arguments.minuteOffset)) AND IsNumeric(arguments.minuteOffset) AND (arguments.minuteOffset LTE 59 AND arguments.minuteOffset GTE 1) ) tzMinOffset = arguments.minuteOffset; else { // If minuteOffset is not provided, use the GetTimeZoneInfo() values to use Server's TimeZone information if ( StructKeyExists(tzData,"utcMinuteOffset") ) tzMinOffset = tzData.utcMinuteOffset; } // Set the timezone operator use (Proper ISO8601 format): // - (-) for timezones west of UTC (such as a zone in North America) // - (+) for timezones east of UTC (such as a zone in Germany) if ( tzHrOffset LTE 0 ) tzOperator = "-"; // Build the timezone stamp tzStamp = tzOperator & NumberFormat(ABS(tzHrOffset),"00") & ":" & NumberFormat(tzMinOffset,"00"); // Build the string return DateFormat(arguments.date,"yyyy-mm-dd") & "T" & TimeFormat(arguments.time,"HH:mm:ss") & tzStamp; var dateFields = StructNew(); dateFields.year = year(arguments.date); dateFields.month = month(arguments.date); dateFields.day = day(arguments.date); dateFields.hour = hour(arguments.time); dateFields.minute = minute(arguments.time); dateFields.second = second(arguments.time); return dateFields;