I had the same problem. I could apply formatting in the Studio for a text
field but I lost that capability when I converted it to an HREF. In my
case, the data was returned by a stored procedure and the solution was
simply to change the stored procedure to provide me with the format I
needed. Simple.
Roger
-----Original Message-----
From: Moganna, Prasad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 05, 1999 10:12 AM
To:
'[EMAIL PROTECTED]'
Subject: [ND] Changing the format of Date Time field
associated to a datao bject
I have a dataobject having 5 fields. One among them
is a date time
field. This dataobject
is bound to a repeated object in a ND page. The repeated
object has 5
display fields all of which
are href's. The requirement is the date time object should
be formatted like
this:
'MM/DD/YYYY HH:MM PM ' CST
Eg: 05/05/1999 10:00 AM CST
I have set the partial text override and the sql text select
is being
overwritten in the wizard
whenever I give TO_CHAR(DateField, 'MM/DD/YYYY HH:MM PM') ||
' CST' , it
gives me the following
software messages in my page.
doWFRptDetail.convertDataFieldValue: Unexpected Exception
(spider.session.CSpDatetimeParsingException:
parseTimeFromString: invalid
substring (CST) when
parsing '09:05 AM CST' [null]) caught in 'doWFRptDetail'(a
NewsWeb.doWFRptDetail) [Parent:
'NewsWeb'(a NewsWeb.NewsWeb)]. Top of stack:
|spider.session.CSpDatetimeParsingException:
parseTimeFromString: invalid substring (CST) when parsing
'09:05 AM CST'
[null] at
java.lang.Throwable.<init>(Compiled Code) at
java.lang.Exception.<init>(Compiled Code) at
spider.util.CSpSpiderException.<init>(Compiled Code) at
spider.util.CSpSpiderException.<init>(Compiled Code) at
spider.session.CSpValueConversionException.<init>(Compiled
Code) at
spider.session.CSpDatetimeParsingException.<init>(Compiled
Code) at
spider.session.CSpDatetime.parseTimeFromString(Compiled
Code) at
Can anyone please help me on this.
Thanks in advance,
Prasad
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the
discussion
forums, please go to:
http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
