I've converted to ad_form and it's now working.
I used:
{meetingdate:date,to_sql(linear_date),from_sql(sql_date)
{label "Date"}
{format "YYYY-MM-DD HH24:MI"}
{today}
{help}
{value {$meetingdate}}}
copied from the happenings example. Where are the fields documented?
I had to use:
to_timestamp(:meetingdate,'YYYY MM DD HH24 MI SS')
and:
to_char(meetingdate, 'YYYY MM DD HH24 MI SS') as meetingdate
to convert to sql and from sql the date format.
Is this correct?
