similar to: Date Calculation

Howdy folks, As I was putting together a rough form for a rails app, I got to thinking how much smoother (in my siytuation) a little calendar widget would be than the default date picker selects. Does anyone know if such a thing exists ? I suspect it would have to be somewhat designed with rails in mind to populate the right kind of post params for convenient use at the controller end.

Hi, How do i convert a Date to a Time?? I have a date returned from sql and i need to be able to use handy functions like next_week or beggining of week. Any help appreciated Thanks, Chris -- Posted via http://www.ruby-forum.com/.

Hi, I''m stuck. How do you parse a "dd/mm/yyyy" formatted date string??? I get a date format error. Thanks in advance Greg --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to

I tried to use ''rake db_schema_dump'' from old MySQL database and then use ''rake db_schema_import'' to rebuild the database in PostgreSQL. The issue here is that only some of tables can be imported successfully. For example, in the dumped schema.rb: create_table "profiles", :force => true do |t| t.column "ticker", :string, :limit

Howdy all, This may be the dumbest question in the world, but how can you "add one month" to a Date object? I can''t just add 30 days, because months have varying lengths. Any help would be much appreciated... Thanks! -Neal --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails:

I''m having a problem converting a date retrieved from my MySQL database and I''m hoping someone can help. MySQL stores the date/time as this: 2005-03-08 17:00:34.0 and according to my Pickaxe book Ruby stores times as "the number of seconds and microseconds since [...] January 1, 1970". All well and good. Unfortunately, RoR is converting my date to this:

I''m trying to add an RSS feed to my app, and am going through the Rails Recipes chapter on doing so. I get the following error when I request the feed: undefined method `gmtime'' for #<DateTime: 1963061961/800,0,2299161> ... 7: xml.pubDate CGI.rfc1123_date(@posts.first.created_on) Any idea what''s up? Pat

Hi When returning data from a database column set as a date field I get ''2006-06-06'' I am then have these two lines of code in my controller, taht gain the date I require. pNow = Time.now @pDate = Time.local(pNow.year, pNow.month, 1) At the monment one is set to a date data type while one is set to a Time data type. how can i change these to be the same data type so i can

In my view code, I have <%= datetime_select "in_out", "time_in" %> which returns in params :in_out: !map:HashWithIndifferentAccess time_in(1i): "2006" time_in(2i): "6" time_in(3i): "12" time_in(4i): "20" time_in(5i): "24" and I want to save that datetime to a column in the db... if

All, My initial list is rather busy. I would like to shorten the created_on and updated_on fields to just display the date, not the time. Best wold be a simple 12/28/05 type of presentation. I''ve found the format helpers in rdoc. (ie. distance_of_time_in_words_to_now ), but none seem to be what I''m looking for. How do I control the date format of a timestamp field? Thanks

What I want to do is simple. I''d like code that prints out the name of this month (January) the next month (February) and the one after that (March) I''ve been able to print this month: <% t = Time.now %> <%= t.strftime(" This Month is: %B") %> But I can''t figure out how to get the next months to print out! -- Posted via

Hi Experts I''ve a product like this ID -> 1 Name -> Xyz Price -> 30 Created_at -> 02-NOV-07 from_date = Date.new(2, 10, 07) to_date = Date.new(2, 10, 07) @product = Product.find_by_sql("select * from products where created_at between from_date and to_date") code works perfectly, buy my issue is i dont get any data. always says no record found but if i use

Hi, I have MySQL model with created_on specified as :date. This means that the day the record was created on is stored in the database as a string like "2006-04-28". I want to be able output a something like "5 days ago". From looking in the API I''ve found "strftime" and "*distance_of_time_in_words*". Distance_of_time_in_words only accepts Time

I''m using the date_select and datetime_select helpers in my view, and they return Date classes from the params hash. But how do I work with Date classes, they don''t print human readable dates or times, Time classes work well I can use strftime("%H:%M") to print to the screen. Is it possible to convert a Date to a Time, Ive been tinkering in irb but have got

Hi, I''ve implemented the login code from the Agile rails book and it works perfectly in local development but as soon as I put it into production it wont accept usernames/passwords. It just goes straight back to login page. Any ideas? thanks -- Posted via http://www.ruby-forum.com/.

Hi, I was wandering if anyone could help me with this problem: Right now I am using a field in my database which is of type ''Date'' (in the form dd-mm-yyyy). I would like to convert this value (for example 26-06-08) into a number of seconds since epoch or into another form so I can compare it with todays date (from Date.now) so that I can tell the difference between the two dates

Hi, I was trying to use the :select parameter to select a calculated row, but it appears that the parameter is not picked up by the paginate method. I want to add the following to the select statement: timediff(now(), created_on) as age So I tried: @story_pages, @stories = paginate :stories, {:per_page => 10, :include => ''user'', :select =>

I have a model which has the created_on and updated_on fields. I would like to find the newest instances of my model from the database(for instance, last 10), but as I''m only 6 weeks into my Rails development, I''m not entirely sure how to do it. Any suggestions? Thanks, David

Thanks for the bug report! I''ll get a new release out next week, I''ve been on vacation for a few weeks and I''m just getting up to speed with being back in a city. In the meantime, the fix is to apply the following patch (in Icalendar.decode_duration). I''ve also integrated your tests, thanks. Cheers, Sam diff -u -r1.22 icalendar.rb --- vpim/icalendar.rb 17

All I want to do is find the objects that were created today under the ''created_on'' column. I''ve tried many ways, here is one example using the chronic gem. @products = Product.find_all_by_created_on(Chronic.parse(''today'')) I must be missing something right in front of me .... Thanks for any help.