Updated to 3.0 - list format not rendering properly

[cmendla]

I just update everything to the latest release. The site is running on j 2.5.14.

I have a page at http://www.bcsbc.com/tour-schedule-notice.html

There is a list at the bottom of that page.

The results look like

2013-10-23 -- %pm %b 23 2013 --- %1:15 %p   
2013-10-30 -- %am %b 30 2013 --- %1:15 %p   
2013-11-06 -- %am %b 06 2013 --- %0:15 %p   
2013-11-13 -- %pm %b 13 2013 --- %0:15 %p   
2013-11-20 -- %am %b 20 2013 --- %0:15 %p

Beforehand it looked like

2013-10-30 -- Wed Jan 30 2013 --- 61:15 pm

Note - it renders correctly in the dropdown box. However, the dropdown box is a database join with a concatenation of

DATE_FORMAT(CONVERT_TZ({thistable}.tourdate,'+00:00','-04:00'),'%Y %m %d --- %a %b %d %Y --- %r ')

The formatting strings I am using in the element is

List format %Y-%m-%d -- %D %M %d %Y --- %H:%M:%S
Form Format %Y-%m-%d -- %D %M%d %Y --- %H:%M:%S

If I tried a list format of %Y-%m-%d -- %D %M %d %Y --- %H:%M:%S
I get 2013-10-30 -- 10/30/13" 15 30 2013 --- 11:15:00

If I try a list format of %Y %m %d --- %a %b %d %Y --- %r
I get 2013 10 30 --- %am %b 30 2013 --- "11:15:00 am

A list format of %c
I get %2013-10-23T18:15:00-04:00


I'd appreciate any thoughts on how to get this working correctly.

I am using the reference at http://us2.php.net/manual/en/function.date.php

thanks

chris

 

[rackem]

You are posting in the Fabrik 3.1 forum so I assume that is what you have upgraded to?

http://fabrikar.com/forums/index.php?wiki/upgrading-from-3-0-to-3-1/
Note the date formatting change

 

[cmendla]

Rackem

THANKS - I was looking at it before but didn't see the difference in the dates.

I am now using a format of D F jS, Y - g:i A which gives Wed December 4th, 2013 - 11:15 AM which is exactly what I needed.