Forum OpenACS Q&A: Forms: Date type, Avoiding --

Collapse
1: Forms: Date type, Avoiding --
Posted by defunct defunct on 10/09/02 12:40 PM
Hi,

At present the forms api, when you use a date field, if the current time is at 00 minutes, then the provided form button has
'--' displayed in it, obviously this is unlikely to ever successfully submit into a database field as -- is not a valid time.

Is there a simpe way around this? Or is this a bug that been/not been fixed?

Thanks

Collapse
2: Response to Forms: Date type, Avoiding -- (response to 1)
Posted by Stan Kaufman on 10/10/02 08:35 PM
I hope I'm tracking your question correctly: what I've found to work is to strip out the time entirely before passing the value to ad_form and then reconstructing a date format that the DB is happy with later. For example (using PG): 

set now [db_string now_str "select to_char(current_timestamp,'YYYY MM DD') from dual"]

ad_form -name test -form {
   {start_date:date
      {label "Start Date"}
      {value $now}
   }
} -new_data {
   set start_date_ansi "[lindex $start_date 0]-[lindex $start_date 1]-[lindex $start_date 2]"
   db_transaction {
      do the insert etc..
   }
}

There may well be a more elegant way to use the API than this, but this does definitely work.