-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
]
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
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,
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
@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
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
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
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
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
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
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
11 matches
Mail list logo