tracker issue : CF-3336205

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

[ANeff] Bug for: cfschedule falsely says exclude date format invalid

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/NotABug

Reporter/Name(from Bugbase): Aaron Neff / Aaron Neff (Aaron Neff)

Created: 09/24/2012

Components: Scheduler

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: Final /

Priority/Frequency: Minor / Very few users will encounter

Locale/System: English / Windows 7 SP1 64-bit

Vote Count: 0

Currently, for the exclude attribute:
1) date/time objects are valid, even in an array
2) numeric dates are only valid if not in an array
3) date/time objects and numeric dates cannot be mixed

Repro cases:

This works (exclude is now()):

<cfschedule action="update" task="myTask" startdate="1/1/2012" starttime="12:00 AM" interval="3600" url="http://a" exclude="#now()#" />
<cfschedule action="list" task="myTask" result="q" />
<cfdump var="#q#" />

This works (exclude is now() w/in array):

<cfschedule action="update" task="myTask" startdate="1/1/2012" starttime="12:00 AM" interval="3600" url="http://a" exclude="#[now()]#" />
<cfschedule action="list" task="myTask" result="q" />
<cfdump var="#q#" />

This works (exclude is now()+1):

<cfschedule action="update" task="myTask" startdate="1/1/2012" starttime="12:00 AM" interval="3600" url="http://a" exclude="#now()+1#" />
<cfschedule action="list" task="myTask" result="q" />
<cfdump var="#q#" />

This fails (exclude is now()+1 w/in array):

<cfschedule action="update" task="myTask" startdate="1/1/2012" starttime="12:00 AM" interval="3600" url="http://a" exclude="#[now()+1]#" />
<cfschedule action="list" task="myTask" result="q" />
<cfdump var="#q#" />

This fails (exclude is now(),now()+1):

<cfschedule action="update" task="myTask" startdate="1/1/2012" starttime="12:00 AM" interval="3600" url="http://a" exclude="#now()#,#now()+1#" />
<cfschedule action="list" task="myTask" result="q" />
<cfdump var="#q#" />

This fails (exclude is now(),now()+1 w/in array):

<cfschedule action="update" task="myTask" startdate="1/1/2012" starttime="12:00 AM" interval="3600" url="http://a" exclude="#[now(),now()+1]#" />
<cfschedule action="list" task="myTask" result="q" />
<cfdump var="#q#" />

The first three work. The last three fail.

The exception is the same for the three that fail: "The date format used in exclude atribute is not valid. Provide a commonly used date format."

Issue:
- numeric dates should be valid in an array
- date/time objects and numeric dates should be mixable

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3336205

External Customer Info:
External Company:  
External Customer Name: itisdesign
External Customer Email:

Attachments:

Comments:

A date is valid if lsisdate(date) function returns true. (now() + 1) returns NO. Other option is to use dateformat function to format dates before passing it to exclude attribute
Comment by Uday O.
17956 | September 30, 2013 02:51:46 AM GMT
Hi Uday, You closed this ticket b/c you said exclude disallows now() + 1 b/c it fails lsIsDate(). Well.. this successfully creates a task: <cfschedule action="update" task="myTask" startdate="1/1/2012" starttime="12:00 AM" interval="3600" url="http://a" exclude="#now()+1#" /> Can you please re-open this ticket? Thanks!, -Aaron
Comment by External U.
17957 | February 28, 2014 01:19:17 AM GMT