MS Access 2002
The following code works on my server/DB, but I am concerned about
portability. The concern is that the dates are in different formats. And,
yes I am guilty of being the hacker/creator, but I can't see a more elegant
way to accomplish the task.
OUTPUT:
End Date: {d '2003-11-19'}
Start Date: {ts '2003-11-07 00:00:00'}
Any suggestions?
Thanks,
Nick
<cfset StartDate = DateAdd("d", -12, URL.EndDate) >
<p><cfoutput>
EndDate: #URL.EndDate#<br>
StartDate: #StartDate#
</cfoutput></p>
<cfquery name = "GetResults" dataSource = "Events">
SELECT *
FROM Locations
Where Location = 'LA' AND StartTime BETWEEN #StartDate# and #URL.EndDate#
</cfquery>
StartTime Location Event<BR>
<cfoutput query="GetResults">
#StartTime# #Location# #Event#<BR>
</cfoutput>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
