At 05:17 PM 10/28/2005, Bobby Hartsfield" wrote: >Even easier, once you have the dates just check to see if now() is > >A) GTE EndDateTime OR LTE StartDateTime >B) GTE StartDateTime AND LTE EndDateTime > >A being true means grant access >B being true means deny access
Hey, I'm trying to implement that solution, comparing today's date with a date I have in a database (unfortunately, the DB I inherited has the date stored as individual dd, mm, yy, hh, mm, and ss fields). So I create my date with: <cfset endTimeDate= '#qry.applCloseMonth#/#qry.applCloseDay#/#qry.applCloseYear# #qry.applCloseHour#:#qry.applCloseMinute#:#qry.applCloseSecond#'> (again, from individual fields in the DB) ....and then I create thisDate: <cfset thisTime='#DateFormat(Now(), 'mmm/dd/yyyy')# #Hour(Now())#:#Minute(Now())#:#Second(Now())#'> ....and although both dates print exactly the same on the screen, the comparison between them does not trigger an "earlier that" or "later than" behavior (I'm using GTE and LTE). Any suggestions on how to make it work (considering how the date is stored in the DB)? Thanks in advance, Roberto Perez [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222691 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
