searching between two date

rubyonrails-talk
1

Hi    In model i have (as part of find statement)     sd.created_on <=> (sd_ticket_start_date..sd_ticket_end_date)

    (Here i am using ez_where plugin So <=> means BETWEEN) And for example I am passing dates from view like <%= text_field "sd_ticket", "end_date",:value=>Time.now.strftime('%m/%d/%Y') %>    I know created_on field is saved in the format '2008-07-30 18:22:11.30577' So my problem is if I pass both dates(start and end date) equal say 07/31/2008 from view I dont get the records which are created on 07/31/2008

So in model how can I format the value in sd_ticket_start_date ( 07/31/2008 ) to the format '2008-07-30 18:22:11.30577' like that.

Thanks in advance Sijo

2

the database is including the time in the search. so make sure, that either enddate has a time of 23:59:59 or is the next day at 0:0:0

3

I looked in log file The query formed is SELECT * FROM service_desk_tickets WHERE ((service_desk_tickets.created_on BETWEEN '07/31/2008' AND '07/31/2008')) ;

    Here if I create two ticket in this date(07/31/2008) at 11.30 AM and 11.45 PM for example I dont get it on the search .And to get todays record I have to enter startdate as 07/31/2008 and end date 08/01/2008 (mm/dd/yyyy)

Sijo

4

The possible solution for this would be I suppose to compare start and end before passing it to the sql query.

you would be comparing it for whether start-date is less than end date or not. Likewise, have a similarity comparision and if it equals pass it on to the query for that respective date alone.

Thanks&Regards, Kiran.