\
**Category:** Rails\
**Created:** [July 27, 2008, 9:58pm UTC](https://www.ruby-forum.com/t/dhtml-calendar-plugin-and-dates/144261 "2008-07-27T21:58:24Z")\
**Posts on this page:** 2\
**Page:** 1
**Author:**  [@thor](https://www.ruby-forum.com/u/thor)\
**Post date:** [July 27, 2008, 9:58pm UTC](https://www.ruby-forum.com/t/dhtml-calendar-plugin-and-dates/144261/1 "2008-07-27T21:58:24Z")
Man I am frustrated. 4 hours working on this and i can’t find an
answer. Here it goes.
I had some simple date select fields on a form. Then I wanted to add
some additional datetime fields on a form with a nice widget so I
installed the dhtml\_calendar plugin. Now my migrations and forms don’t
work on insert stating that the argument is out of range.
Here is line #62 in the plugin:
when Date then “’#{quoted\_date(Time.local(value.year, value.month,
value.day, 0, 0, 0))}’”
I believe it’s got something to do with the date format (2007-12-23)
that i’m using but I can’t figure it out. HELP!
vendor/plugins/dhtml\_calendar/lib/extensions/active\_record.rb:62:in
`local' vendor/plugins/dhtml_calendar/lib/extensions/active_record.rb:62:in`quote’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/connection\_adapters/mysql\_adapter.rb:221:in
`quote' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2576:in`attributes\_with\_quotes’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/base.rb:2574:in
`each' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2574:in`attributes\_with\_quotes’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/base.rb:2496:in
`create_without_callbacks' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/callbacks.rb:220:in`create\_without\_timestamps’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/timestamp.rb:29:in
`create' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2472:in`create\_or\_update\_without\_callbacks’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/callbacks.rb:207:in
`create_or_update' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2206:in`save\_without\_validation!’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/validations.rb:911:in
`save_without_dirty!' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/dirty.rb:83:in`save\_without\_transactions!’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/transactions.rb:110:in
`save!' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in`transaction’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/transactions.rb:79:in
`transaction' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/transactions.rb:98:in`transaction’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/transactions.rb:110:in
`save!' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/transactions.rb:118:in`rollback\_active\_record\_state!’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/transactions.rb:110:in
`save!’
---
**Author:**  [@thor](https://www.ruby-forum.com/u/thor)\
**Post date:** [July 28, 2008, 10:43am UTC](https://www.ruby-forum.com/t/dhtml-calendar-plugin-and-dates/144261/2 "2008-07-28T10:43:47Z")
Hello,
First of all, you should always post your environments settings with
your question.
I think you could try and parse the string you receive to a date
before inserting it into the database.
Something like parsed\_date = Date.parse(params[:date\_field]) should do
the tric
I hope it helps you.
Geoffroy