Just looking at the error message, it looks as if you have the date in single quotes.
Try taking them off.
Frank Hilliard
"Brown, Brian" wrote:
> Has anyone had any problems using the DateDiff function. We developed a
> site on M$ and we are now porting it over to a Red Hat box and were are
> having a fit with the DateDiff function when checking client variables.
>
> The error says
>
> -------------------------------------------------
>
> An error occurred while evaluating the expression:
> DateDiff("n", Now(), client.expires) GT "0"
> Error near line 15, column 44.
> Parameter 3 of function DateDiff which is now "'2001-03-27 12:34:18'"
> must be a date/time value
> ---------------------------------
>
> we are a little baffled. the CF server is 4.5 with sp2 and red hat
> version 6.2 running postgresSQL
> thanks for any help,
> brian
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
