Have you tried using the datecompare or datediff functions? I don't think
you need to change the format of now() to get what you need. Are you trying
to see if the date is before, after or the same as now()? If so, use
datecompare.
<cfset result = datecompare("2000-11-04 00:00:00", now() , "d")>
--
Chris Giminez
Owner - Cyber Scriber Web Site Design
831-728-4469
ICQ# 2628000
>
> 2000-11-04 00:00:00
>
> and I want to compare it against now() in the format:
>
> {ts '2000-07-05 00:00:00'}
>
> I'm fairly new to cold fusion and I'd like to hear any easy suggestions
> of changing now() into the first format..
>
> {ts '2000-07-05 00:00:00'} to just 2000-07-05 00:00:00
>
> I've tried the DateFormat function but that doesn't give you the
> hours:min:sec part... and I tried to add a second to it with the DateAdd
> function to give me the time part of it back.. and it converts the whole
> thing back to {ts '2000-07-05 00:00:01'}
>
> Help!...
>
> Thanks in advance!
>
> Lee
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
