search : date/time functions

select a category, or use search below
(searches all categories and all time range)

displaying top 100 results

Comment on new date/time function for returning date/time/datetime in ISO8601 by External U.
Comment on new date/time function for returning date/time/datetime in ISO8601 by External U.
Comment on new date/time function for returning date/time/datetime in ISO8601 by External U.
Comment on new date/time function for returning date/time/datetime in ISO8601 by External U.
Comment on new date/time function for returning date/time/datetime in ISO8601 by Immanuel N.
new date/time function for returning date/time/datetime in ISO8601
Comment on CFFiddle for Spreadsheet, List, Struct, and Date/Time functions by Saurav Ghosh
CFFiddle for Spreadsheet, List, Struct, and Date/Time functions
Comment on new date/time function for returning date/time/datetime in ISO8601 by External U.
Comment on new date/time function for returning date/time/datetime in ISO8601 by Aaron N.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
Aaron Neff Type-Specific vs Type-Casting member functions Hi CF Community, I’d like to get your opinions. Would you prefer CF’s member functions to be type-specific or type-casting? Currently they are type-specific. These work: myString.dateTimeMemberFunction() myString.numericMemberFunction() myNumber.stringMemberFunction
3557837 CF-4199892 Language : DateTime Functions Aaron Neff [ANeff] Bug for: CF passes date by reference Issue: CF passes date by reference Repro: function myFunction(required date myDateTime) { ARGUMENTS.myDateTime.setYear(2018); } myDateTime = createDate(2017,1,1); myFunction(myDateTime
Comment on new date/time function for returning date/time/datetime in ISO8601 by External U.
4161070 CF-4201805 Aaron N. Also, implementing this would create conflict with DateTime's .format(), if ever a future CF version adds DateTime member functions onto numeric. So that is a second reason for deferral.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
4486139 CF-4202965 Language : DateTime Functions DateConvert Function seems corrupt. Problem Description: Using DateConvert() inside DateAdd() creates a corrupt date/time object. Please refer to this conversation https://forums.adobe.com/message/10459206#10459206 Steps to Reproduce: Please refer
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
2612885 CF-3374275 Nikhil S. 1) adding member functions setYear(), setMonth(), setHour(), setMinute(), setSecond() for a date object 2) adding following additional createDateTime() functions YearWasSet = createDateTime(2012); // all other components use 0/1 as most appropriate month
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
2609055 CF-3940802 Language Adam Tuttle Please make date member functions consistent. The only date member functions that require the "date" prefix in the method name are: date.dateFormat(), date.timeFormat(), and date.dateTimeFormat()... All other date member functions have dropped the "date
2672816 CF-4165524 Language : DateTime Functions e-domizil License Team Datetime functions return incorrect / inconsistent results Problem Description: Several date functions return incorrect results and are inconsistent. It is also not working as written in documentation. Is
6680860 CF-4206764 Language : DateTime Functions isDate function assumes numeric list is a valid date Problem Description: If you create a list variable with a comma separated numeric values, the isDate function assumes it is a valid date Steps to Reproduce: Actual Result: Yes (true) {ts
2906304 CF-4198390 Language : DateTime Functions Mark Hetherington LSParseDateTime returns date shifted by one hour Problem Description: Since an update to 10.0.22 from 10.0.18 LSParseDateTime shifts dates by DST offset unexpectedly. Steps to Reproduce: Set system timezone to NSW/Sydney (AEDT
Format() doc simpleDateFormatMasks = ["M", "L", "D", "u", "a"];//Only documented in SimpleDateFormat doc result = queryNew("pattern,isInDateFormatDoc,isInDateTimeFormatDoc,dateFormatOutput,dateTimeFormatOutput", "varchar,bit,bit,varchar,varchar"); commonMasks.each(function(element) { result
3063199 CF-4198595 Language : DateTime Functions Knut Bewersdorff Using now() in a dateAdd function delivers wrong dates Problem Description: Using 'now()' in a dateAdd function results in wrong date values. Steps to Reproduce: See attached file Actual Result: Wrong dates Expected Result
for all of DateFormat()/TimeFormat()/DateTimeFormat() functionality. Therefore, users should not have to revert to .dateFormat() for DateFormat()'s short/medium/long/full masks. And likewise for TimeFormat()'s. Anyone agree? Adobe? Thanks!, -Aaron
4081263 CF-4201528 Language : DateTime Functions Jack Drysdale Jr CreateDateTime() has an aversion to using '11' for the day part Problem Description: CreateDateTime() does not like me using '11' for the day part. Steps to Reproduce: #aDate# #bDate# #cDate# Actual Result: {ts'2018-03-10 02
2608887 CF-3971009 Language : Functions Michel Monette CF10 CreateDateTime failure Problem Description: I’m having a problem with the CreateDateTime function in CF10. Throws this error: Date value passed to date function createDateTime is unspecified or invalid. Of course 02:00 on March 8th
2827102 CF-4198312 Language : DateTime Functions K Clancy isDate() returning true for numeric values Problem Description: isDate() returns true when a number is passed in Steps to Reproduce: isDate(40675) Actual Result: YES Expected Result: NO Any Workarounds:
,3,9,2,55,26); Actual Result: Error Detail: Specify a valid date in createDateTime function. ErrNumber: 0 Error Message: Date value passed to date function createDateTime is unspecified or invalid. Expected Result: {ts '2014-03-09 02:55:26'} ----------------------------- Additional Watson Details
Tracker Issue Year Format Incorrect
6696669 CF-4206858 Language : DateTime Functions Year Format Incorrect Problem Description: Year format for any dates of 192x (or lower) are presented as 202x instead of 192x Steps to Reproduce: Actual Result: 2028-02-09 Expected Result: 1928-02-09 Any Workarounds:
2611121 CF-3639695 Adobe D. Test case at cfsuite\coldfusion\functions\date-time\datetimeformat\bugCF-3639695.cfm (Comment added from ex-user id:vnigam)
Format() doc simpleDateFormatMasks = ["M", "L", "D", "u", "a"];//Only documented in SimpleDateFormat doc result = queryNew("pattern,isInDateFormatDoc,isInDateTimeFormatDoc,dateFormatOutput,dateTimeFormatOutput", "varchar,bit,bit,varchar,varchar"); commonMasks.each(function(element) { result
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
4875227 CF-4203350 Language : DateTime Functions DateTimeFormat returns different results in CF2016 and 2018 Problem Description: I am using GetHttpTimeString() function to get the current date and time in UTC/GMT. But when I format it using DateTimeFormat, its returning different results. Steps
2608361 CF-4113069 Language : Functions Tim Mixell DateTimeFormat not honoring escape characters per wiki documentation Referencing documentation here: https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-c-d/DateTimeFormat.html Problem Description: when trying
3732699 CF-4200189 Language : Functions [ER]: Additional Member functions Support Other Functions Support {code:java} someVar.chr() someVar.createDateTime([month[, day[, hour[, minute[, second]]]]])//CF-3374275 added support for createDateTime(year) someVar.duplicate() some
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
3557135 CF-4199859 Adam C. Don't agree with a lot of the decision functions being appropriate, but yes to the others. some thought needs to go into ones like createDateTime. Probably a static method on the DateTime class or something? Not all of these functions are appropriate as object methods
Aaron Neff Success: function f5(string myDateTime) { if(isValid("date", trim(myDateTime))) { writeOutput(dateAdd("m", 1, trim(myDateTime))); } } f5(now()) f5("2018-01-01T00:00:00Z") Failure: function f6(string myDateTime) { if(isValid("date", myDateTime
2672621 CF-4183487 Language : DateTime Functions ext-user Require a separate function to differentiate between datetime Object and datetime String. Problem: Require a function to differentiate between datetime Object and datetime String as the current isDate() function returns true for both
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
2612885 CF-3374275 External U. Hi Adam, You're very welcome! Sorry, I just now saw your message. Not sure how I missed it. Also, I now see the following docs were updated: CreateDateTime(): https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-c-d/CreateDateTime
2673556 CF-4126413 S P. The fix will be available in the update 2 of ColdFusion 2016. It has handled the date/time in-built functions and mathematical in-built functions that return integers. Thanks!
Format() doc simpleDateFormatMasks = ["M", "L", "D", "u", "a"];//Only documented in SimpleDateFormat doc result = queryNew("pattern,isInDateFormatDoc,isInDateTimeFormatDoc,dateFormatOutput,dateTimeFormatOutput", "varchar,bit,bit,varchar,varchar"); commonMasks.each(function(element) { result
5190341 CF-4203797 Language : Functions [ANeff] Bug for: dateTimeFormat() inconsistent escaping of string literals Issue: dateTimeFormat() inconsistent escaping of string literals Repro: ----------- myDateTime = createDateTime(2018) writeOutput(myDateTime.dateTimeFormat("dddd 'at' HH
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
is an integer week and an integer year. Suggestion: dateTime = createDate(2016,1,3); writeOutput(week(dateTime, "iso") & ' | ' & year(dateTime, "iso")); Expected result: 53 | 2015 Currently, year(dateTime, "iso") throws exception: "The function takes 1 parameter." It should return the ISO 8601 year
5623587 CF-4204191 Language : DateTime Functions CreateODBCDateTime() with DateFormat() and CreateODBCTime() results in incorrect ODBCDateTime output Problem Description: When creating a ODBC DateTime string, if you Wrap a DateFormat() and CreateODBCTime() in a CreateODBCDateTime(), the Output
7003891 CF-4207741 Language : DateTime Functions Incorrect Date Calculation When Using DateDiff() Problem Description: ColdFusion improperly calculates the difference between two dates if the date is before 1970. Steps to Reproduce: writeDump( dateDiff( 'd', '6/1/1420', '12/31/1967' ) ); Actual
7004065 CF-4207740 Language : DateTime Functions Incorrect Date Calculation When Using DateDiff() Problem Description: ColdFusion improperly calculates the difference between two dates if the date is before 1970. Steps to Reproduce: writeDump( dateDiff( 'd', '6/1/1420', '12/31/1967' ) ); Actual
4409586 CF-4202680 Language : DateTime Functions Datediff using 'w' weekdays option Using the datediff function with the 'w' option, according to documentation, should give you the number of weekdays between date1 and date2. Instead, it gives you the weeks (same result as 'ww' option) output
Bug 86140:-(Watson Migration Closure)[maestrofjp] The function ParseDateTime() incorrect parses Unix Datetime strings
of the info. If weekYear() won't be added, then the "iso" attribute should be removed from all date/time functions. Then users can just use dateTimeFormat() masks to get the ISO week number, ISO week year number and ISO day of week. It just seems odd to use a formatting function to get all that info tho
2608415 CF-4100122 Language : Functions Aaron Neff [ANeff] ER for: ISO 8601 support in dayOfWeek() dayOfWeek() doesn't use the ISO 8601 standard. #3765535 and #3917706 are updating the date/time format functions to support ISO 8601. This ER is to do the same for dayOfWeek(). Example: dateTime
2672497 CF-4194962 Language : DateTime Functions Shawn Oden DateFormat() and DateTimeFormat() Returning Inconsistent Values Problem Description: The DateFormat() and DateTimeFormat() functions return inconsistent values based on the capitalization of the mask. Steps to Reproduce: n = createDateTime
3653683 CF-4200077 Language : DateTime Functions Steve Sommers TimeFormat backward compatibility bug Problem Description: TimeFormat minute mask is not backwards compatible with earlier versions - m or mm. Steps to Reproduce: #TimeFormat(now(),"hh:mm:ss")# Actual Result: 12:mm:35 Expected Result
DateConvert("local2Utc",now()) Breaks Other Date/Time Functions
2608380 CF-4105828 Documentation : General Alexander Kwaschny dateTimeFormat("YYYY") increments year for dates between December 27 and December 31 Problem Description: The dateTimeFormat function returns an incremented year value when using the uppercase year mask when the date to format lies
2613366 CF-3328875 Language Dave Cordes TimeFormat Function Bug w/Local2Utc Duplicate ID: CF-3323800 Problem Description: Formatting a date/time string using the Local2Utc function reverts to the local server time. Steps to Reproduce: Actual Result: Actual result for the timestamp
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
2608204 CF-4163932 Immanuel N. Fix tested on 300359. Testcase already exists in cf/../coretests\coldfusion\functions\date-time\bugs
2608732 CF-4014660 Kailash B. Fix verified in build: 295738 Platform checked on: Win7 x64 Test case used: //depot/qa/cf/regression/coretests/coldfusion/functions/date-time/lsdatediff/
, "ww")); writeOutput(' ' & dateTimeFormat(dateTime, "W")); writeOutput(' ' & dateTimeFormat(dateTime, "WW")); Actual and Expected output: 6 06 1 01 But they are undocumented: https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-c-d/DateTimeFormat.html They should
4331907 CF-4202449 Language : Functions [ANeff] Bug for: IsDate()/ParseDateTime() vs LSIsDate()/LSParseDateTime wrt DateTimeObject and ISO8601 Issues: IsDate()/ParseDateTime() vs LSIsDate()/LSParseDateTime wrt DateTimeObject and ISO8601 Issue 1 (LSParseDateTime doesn't honor DateTime
2613071 CF-3347145 Language : Functions ext-user Extension to 3309220 . Change of behaviour from CF 9 when persisting UTC date/time UTC date/time values become local date/time values upon inserting in to database. ----------------------------- Additional Watson Details
2610457 CF-3700853 Language Adam Cameron Deprecate ODBC functions, enhance date-formatting functions See: http://cfmlblog.adamcameron.me/2014/01/bugs-in-odbc-datetime-formatting.html Recommend deprecating ODBC functions,instead just adding a mask "ODBC" to dateFormat(), timeFormat() and dateTime
5665413 CF-4204276 Language : Member Functions ParseDateTime() conversion issue Problem Description: Date/Time values from a database query, when run through ParseDateTime() are not converted to valid datetime objects. Instead, they retain their original string value, causing all sorts of issues
Michaela Light Better Time and Number Formats with ColdFusion In this article, you will learn: Why these functions are so important for CIOs The ColdFusion Number Format The ColdFusion Date Format The ColdFusion Time Format The ColdFusion DateTime Format What makes these functions are so important
2608417 CF-4099971 External U. Hi Adobe, This doc bug ticket is marked Closed/Fixed. It is not fixed. The doc was never updated. To verify, please see the URL in this ticket's description (which is: https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-c-d/DateTime
, "iso") & "");//returns 53 (good) writeOutput(weekYear(dateTime, "iso"));//would return 2015 (per this ER) The ISO week for that date is "2015-W53". Meaning, the ISO 8601 "week year" is 2015. But, year(dateTime) will return 2016. Currently there is no function to get the ISO "week year" 2015
problems when they use the doc's Example code, and then replace DateFormat() and TimeFormat() with i.dateTimeFormat() (b/c Numeric doesn't have a .dateTimeFormat() member function). Suggestions: 1) Change the index attribute's description from this: ----------- Index value. ColdFusion sets it to the from
2609313 CF-3859758 External U. I agree in principle with the Adam and Tom. Adobe is too aggressive with trying to accommodate date/time fragments. Maybe we need an IsTime() function to validate time-only strings, and only have IsDate() return true for valid dates or full date/time strings. In any
4081253 CF-4201527 Language : DateTime Functions Jack Drysdale Jr Can't add 2 hours to a date object created with CreatDate() Problem Description: I cannot add two hours to a date object created with CreateDate(y,m,d). I can add one hour, I can add three hours, I can add four hours, but two hours
's type to a date/time or number. Suggestions: 1) ToDate() headless function 2) ToNumber() headless function 3) .toDate() member function added to all simple data types except DateTime 4) .toNumber() member function added to all simple data types except Numeric ones #1 and #3 would convert a simple
2684208 CF-4198173 Sean C. I've found this happens when you have your server set to a non-UTC timezone. We have ours set to EST. It also happens with other date functions such as parseDateTime().
2609162 CF-3917706 External U. Well it's two different things. "week" and "week date". One is analogous to the current week() function, and one is analogous to a variation of dateTimeFormat()
4181439 CF-4201890 Language : Member Functions [ANeff] ER for: simpleValue.date|time|dateTimeFormat() Note: The language should be predictable. If someDataTypeBIF(myVariable) works, then myVariable.someDataTypeBIF() should also work. This ER is for simpleValue.date|time|dateTime
2612794 CF-3429713 Language Aaron Neff [ANeff] ER for: millisecond() and createDateTime(year,month,day,hour,minute,second,millisecond) Currently, there is no millisecond() function and createDateTime() doesn't support a millisecond parameter. Please consider this example: myVar = createDateTime
be allowed by adding a myDate.timeZone(newTZ[, adjustDT]) member function. The newTZ parameter would be the new time zone designation to apply. The adjustDT boolean parameter would signify if the date/time should also be adjusted. And datePart()/myDate.datePart() could also accept "tz" for the datepart
2609162 CF-3917706 Language Aaron Neff [ANeff] ER for: ISO 8601 support in week() week() doesn't use the ISO 8601 standard. #3765535 is updating the date/time format functions to support ISO 8601. This ER is to do the same for week(). Example: week(now(), "iso") Related tickets: #3915699
Version 1 (uses BIFs) component { string function len(required string myString) { return len(myString) } numeric function floor(required numeric myNumeric) { return floor(myNumeric) } date function day(required date myDateTime) { return day(myDateTime) } } Then CF added member
d, yyyy')# at #timeFormat(now(),'h:mm tt')# …but why use two functions when you can use one, right?  So I tried using the following: #dateTimeFormat(now(),'dddd, mmmm d, yyyy at h:mm tt')# But got briefly stuck when the ‘t’ in the date […] The post Quick tip: escaping string literals in dateTime
2609984 CF-3739355 Adobe D. Issue is with mozilla browser not being able to parse given string as date. Workaround is to use cf function like createDateTime(2003,6,11,10,50,32) and pass the date object to dateFormat. (Comment added from ex-user id:sandeepp)
Comment on CFFiddle for Spreadsheet, List, Struct, and Date/Time functions by James Mohler
3557135 CF-4199859 Aaron N. Hi Adobe, someVar.numberFormat() should've been someVar.format() The type-specific 'format' functions don't need the type suffix. Ex: myDate.format() instead of myDate.dateTimeFormat() myNumber.format() instead of myNumber.numberFormat() Thanks!, -Aaron
2613071 CF-3347145 External U. "the application's responsibility to convert the date/time" Yes, via date"Convert"(). What else would we expect a function named "dateConvert()" to do? The function isn't named "dateMove()", it's named "dateConvert()". From the CF9 and CF10 docs: Returns: UTC
-in-k/isnumericdate.html 2) parseDateTime() by definition parses a date/time string according to the English (U.S.) locale conventions. Hence, expecting it to parse a numeric value to a date is out of its scope.
(2012, 11, 29, 15, 7)); foo.append(createDateTime(2012, 11, 29, 15, 7, 8)); //foo.append(createDateTime(2012, 11, 29, 15, 7, 8, 9));//throws "The function accepts 1 to 6 parameters." :/ writeDump(var=foo, format="text"); Result: ----------- array 1) {ts '2012-01-01 00:00:00'} 2) {ts '2012
2672497 CF-4194962 External U. Note 2: To exacerbate this issue a little, the Adobe docs for DateTimeFormat() say that "The function also follows Java date time mask. For more information, refer to Date and Time Patterns topic in SimpleDateFormat Java API page.", yet the examples show using "MM