I'm working with two dates coming out of some mysql fields. They're formatted like 2007-05-26.
I want to check and see if the current time is in between those dates. if it is, I needta flag it, relocate, etc. What I've got KINDA workin is this: <cfif DateFormat(Now(), "yyyy-mm-dd") GTE getEvalDetails.evalopendate AND DateFormat(Now(), "yyyy-mm-dd") LTE getEvalDetails.evalclosedate> But today is the 18th. If I set evalopendate to the 19th, it still flags it. Not understanding that one! I'm sure I'm doin this wrong. Any suggestions? Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
