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

Reply via email to