yep, this is what I got when using it,
ODBC Error Code = 22008 (Datetime field overflow)
[IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]SQL0180 - Syntax
of date,
time, or timestamp value not valid.
"Olive, Christopher M Mr NMR" wrote:
>
> why not just insert
>
> '#DateFormat(Now())# #TimeFormat(Now())#'
>
> ?
>
> Chris Olive,
> DOEHRS Website Administrator
>
> -----Original Message-----
> From: James Taavon [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 28, 2000 11:22 AM
> To: [EMAIL PROTECTED]
> Subject: Custom Tag for Date and Time
>
> Any one have a custom tag that retrieves both the DateFormat (Now()) and
> TimeFormat (Now()) as one function that can be inserted into a database?
> ----------------------------------------------------------------------------
> --
> 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.
> ------------------------------------------------------------------------------
> 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.
------------------------------------------------------------------------------
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.
