You may need to use Custom SQL and do the datetosecs in variables
before you give it a go.
Just a shot.
Mark Weiss
http://trustthechildren.blogspot.com
On Sep 17, 2008, at 4:48 PM, Tom Ferguson wrote:
Excuse the HTML e-Mail, but I thought the image would help
<Outlook.jpg>
<@datetosecs Orders.CreationDate> in the custom column above will
not return a good date. I get the Invalid Date! response from
@datetosecs.
I can hard code in a date in place of Orders.CreationDate and it
works fine. Orders.CreationDate has 08/08/2008.
I've tried quotes, I've tried format. Everything I can think of to
no avail. If I display <@datetosecs <@Column Orders.CreationDate>>
in the results HTML it works fine.
I'm at my wit's end with this.
TIA
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf