Has anyone come across how to compare a date column in a QoQ, I guess the
issue may be, I'm attempting to create a QoQ from a recordset returned from
cfdirectory.
<cfdirectory action="LIST" directory="#variables.backupFolder#"
name="qDirectoryListing" sort="datelastmodified">
<cfquery name="qTodaysFiles" dbtype="query">
select * from qDirectoryListing where datelastmodified =
#now()#
</cfquery>
Trying to retrieve all records where datelastmodified = today.
When using CFDUMP, datelastmodified is formatted as : "Tuesday, 11 May 2004
05:04:33 PM EST". Although you can perform a cold fusion dateFormat on that
Column.
I guess my question is, is it possible to return only the records where
datelastmodified = #dateFormat(now(),mm/mm/yyyy"#, i.e = today?
This message may contain privileged or confidential information and is
intended only for the individual named. If you are not the named addressee
you should not disclose, disseminate, distribute or copy this e-mail. If you
have received this e-mail by mistake please notify the sender immediately by
e-mail and delete this e-mail from your system. You should rely on your own
virus checking programmes and procedures for checking any attachments.
Please advise us if you wish your name and e-mail address to be removed from
our database.
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
