Sure thing. These are all dealing with recent dates (all within the last 2
weeks.. at least this is when we noticed the problem occurring). We
recently upgraded from Spectra 1.01 to Spectra 1.51, and found this during
testing.
The #AppDate# variable will contain a simple date, such as 9/10/02.
<cfset dayStart = CreateDateTime(year(AppDate), month(AppDate),
day(AppDate), 0, 0, 0)>
<!--- minus 1 second --->
<cfset startTime = DateAdd("s", -1, dayStart)>
<!--- add one day --->
<cfset endTime = DateAdd("d", 1, dayStart)>
<cfa_contentObjectFind
dataSource = "#ds#"
typeid = "#Application.WorkFlowInstanceTypeID#"
bActive = "0"
dtUpdatedAfter = "#startTime#"
dtUpdatedBefore = "#endTime#"
bActiveOnly = "no"
r_stObjects = "stInactiveWF"
>
Thanks,
Jeni Donovan
-----Original Message-----
From: Ken Smith [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 4:26 PM
To: Spectra-Talk
Subject: RE: Last Updated date?
Hi Jeni,
Can you please send an example of the coFind call you were using.
The issue I was referring to is specifically with Microsoft SQL Server. The
raw numeric value of the MSS datetime versus Coldfusion's numeric datetime
is different. I believe one startdate is Dec 30, 1899 vs. Jan 1, 1900.
This may be the ultimate cause of your problem.
--Ken
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
