Will,
It looks like isDate() will do what you need - to see if the string
can be converted to a date
You might want to look at parseDateTime() which will create a date
object from the date string.. may or may not be of any use
<cfset test = "2006-02-11 00:00:00.0">
<cfoutput>#parseDateTime(test)# | #isDate(test)# |
#dateformat(parseDateTime(test), "dd/mmm/yyyy")#</cfoutput>
Regards
Rich
On 11/22/06, Charles Sheehan-MIles <[EMAIL PROTECTED]> wrote:
> I just slapped myself on my forehead, thank you.
>
> This worked fine:
>
> <cfoutput query="rsList">
>
> <cfloop index="thisfield" list="#fieldlist#">
> <cfif IsDate(evaluate("#thisfield#"))>
> #lsdateformat(evaluate("#thisfield#"), "mm/dd/yyyy")#
> <cfelse>
> #evaluate("#thisfield#")#
> </cfif>,
> </cfloop>#CHR(13)#
>
> </cfoutput>
>
>
> On 11/22/06 8:31 AM, "Will Tomlinson" <[EMAIL PROTECTED]> wrote:
>
> > <cfif IsDate(thisfield)>
> > #DateFormat(blahblah)#
> > <cfelse>
> > whatever
> > </cfif>
> >
> > Would that work?
> >
> > Will
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261404
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
