tracker issue : CF-4202680

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

Datediff using 'w' weekdays option

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/Duplicate

Reporter/Name(from Bugbase): Dan Thompson / ()

Created: 05/31/2018

Components: Language, DateTime Functions

Versions: 11.0

Failure Type: Others

Found In Build/Fixed In Build: ColdFusion 11 and 2016 versions /

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Win All

Vote Count: 0

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 this statement - #dateDiff("w",createDate(2017,12,1),createDate(2017,12,31))#

Actual Result: 4

Expected Result: 21

Any Workarounds: create your own custom function to iterate through days and count weekdays.

Attachments:

Comments:

Hi Adobe, I see this ticket is marked "Closed/Withdrawn/Duplicate". Okay. But what is the original ticket's ID? This ticket doesn't say it anywhere publicly-visible. Thanks!, -Aaron
Comment by Aaron N.
28981 | June 06, 2018 05:59:05 AM GMT