How to SEARCH BY DATE ???

[Perero]

Hello!!

I'm having trouble with adding "Date Created" and "Last Modified" fields to Search Form of Cases.

After field added to the Search Form



and "Save and Publish" pressed, only the red asteriks appears instead of "Date Created" field:



The same on Cases tab:




HOW to ADD DATE FIELDS TO SEARCH FORM ???

[paikmoses]

Hey Perero,

Take a quick look at this for managing custom fields: http://sugarcrm.openapp.org/?p=155

Regards,

[Perero]

paikmoses,

for custom fileds it works but I need do search for predfined standard date fields "Date Created" and "Last Modified" and I can't add it to search form!

[paikmoses]

Perero,

Not sure why this is hampering.

[Haney]

I had the same symptoms. I modified line 57 of modules/Opportunities/SearchForm.html. The line number to edit will depend on the slot where you have the fields.

<td class="dataField"><span sugar='slot6b'><input name='date_entered' onblur="parseDate(this, '{CALENDAR_DATEFORMAT}');" id='search_jscal_field' type="text" tabindex='2' size='11' maxlength='10' value="{DATE_ENTERED}"> <img src="themes/{THEME}/images/jscalendar.gif" alt="{APP.LBL_ENTER_DATE}" id="search_jscal_trigger" align="absmiddle"> <span class="dateFormat">{USER_DATEFORMAT}</span></span sugar='slot'></td>

[scrollinondubs]

I'm able to get the "last modified" field into the advanced search using Studio but searching by date on that field doesn't return any results. It looks like the value stored in that field when I check it for a record I've touched is this:

08/12/2008 16:46 by Sean Tierney

I'm guessing when I search for that date and it fails to return that record it's looking for an exact match against that field and failing since it includes a time stamp and username...

The thing that would be really useful is if there was a way to search a window of dates for last modified- have two date fields and be able to see any records modified during those days.

Is there a bounty system for SugarCRM whereby I can pledge a dollar amount and others with the same desire can all pitch in to pay someone to build this feature? thanks

Sean

[karkula]

I'm able to get the "last modified" field into the advanced search using Studio but searching by date on that field doesn't return any results...

Look for http://www.sugarforge.org/projects/enhancedsearch/

I have yet to install it. But the question remains why date search cannot be done with Sugar's standard fields.