RE: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday

2008-05-14 Thread Jim Davis
-Original Message- From: Nate Willard [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 14, 2008 1:47 AM To: CF-Talk Subject: Re: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday Dave James. This is for a time tracker tool, so I would like

Re: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday

2008-05-14 Thread Gerald Guido
] Sent: Wednesday, May 14, 2008 1:47 AM To: CF-Talk Subject: Re: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday Dave James. This is for a time tracker tool, so I would like the weekend to start Friday at 6pm... Is there anyway to do a DateCompare

Re: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday

2008-05-13 Thread James Holmes
http://www.cfquickdocs.com/?getDoc=DayOfWeek DayOfWeek() Description: Determines the day of the week, in a date. Returns: The ordinal for the day of the week, as an integer in the range 1 (Sunday) to 7 (Saturday). So, switch DayOfWeek(Now()) case 1,7 - weekend. On Wed, May 14, 2008 at 9:38 AM,

RE: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday

2008-05-13 Thread Dave Francis
Check out DayOfWeek(Now()). IIRC 1=Sun, 7=Sat -Original Message- From: Nate Willard [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 13, 2008 8:38 PM To: CF-Talk Subject: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday Any suggestions on how to determine

Re: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday

2008-05-13 Thread Nate Willard
@houseoffusion.com Sent: Tuesday, May 13, 2008 9:27:16 PM Subject: RE: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday Check out DayOfWeek(Now()). IIRC 1=Sun, 7=Sat -Original Message- From: Nate Willard [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 13

Re: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday

2008-05-13 Thread James Holmes
being Fri 6pm - Sunday 10pm? Thanks! - Original Message From: Dave Francis [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 13, 2008 9:27:16 PM Subject: RE: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday Check

RE: DateCompare Question

2003-02-06 Thread Cantrell, Adam
Why not wrap a dateFormat() around the two compared values? Adam. -Original Message- From: Double Down, Inc. [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 4:25 PM To: CF-Talk Subject: DateCompare Question I have two dates. Once is an ODBC date only that is

Re: DateCompare Question

2003-02-06 Thread Taco Fleur
Not really sure what answer you are after, however, you are aware that 1 = date1 is greater than date2 0 = dates are equal -1 = date1 is less than date2 - Original Message - From: Double Down, Inc. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 07, 2003 8:25 AM

Re: DateCompare Question

2003-02-06 Thread S . Isaac Dealey
If you have a lot of trouble with the datecompare, you could also use something like a mathmatical evaluation: cfif dateformat(date1,mmdd) eq dateformat(date2,mmdd) Accomplishes roughly the same thing. s. isaac dealey954-776-0046 new epoch

RE: DateCompare

2001-04-18 Thread Benekli
Capital H. cfset bnkTime = TimeFormat(now(), 'H') cfif bnkTime GTE 9 AND bnkTime LTE 14 !---// do this --- cfelse !--// do that --- /cfif Benekli23:29P18IV2001 - I am trying to implement a script that will do one function - between 9am and 2pm and

RE: DateCompare()

2000-05-08 Thread jstiefel
Can you not do it with SQL? I would try: cfquery select id fromtable where #Now()# between datecolumn1 and datecolumn2 /cfquery if you get a record back (i.e. recordcount gt 0) then it matched? -Original Message- From: Todd Ashworth