Greetings to everyone!
I've got a problem that had most of you, i think =)
There is an inputtext on my VF page:
<apex:inputText value="{!NewItemReleaseDate}" id="rdate" label="Release Date" onfocus="DatePicker.pickDate(false, this, false);"/> As you can see users enter date here.
Also there is a PageBlockSection that function as a search block:
<apex:pageBlockSection title="Search an item by name and\or release date" collapsible="false">
<apex:pageBlockSectionItem >
<apex:panelGrid >
<apex:outputLabel style="float:left">Name</apex:outputLabel>
<apex:inputText id="searchText" value="{!searchText}" style="float:left"/>
<apex:outputLabel style="float:left" >Date</apex:outputLabel>
<apex:inputText id="searchDate" value="{!searchDate}" onfocus="DatePicker.pickDate(false, this, false);" style="float:left">
<apex:param value="{0,date,MM/dd/yyyy}" assignTo="{!searchDate}"/>
</apex:inputText>
<apex:commandButton id="SearchButton" value="Search" action="{!ViewData}" reRender="FullFunctionalityForm">
<apex:param value="WHERE name=" assignTo="{!searchStr}"/>
<apex:param value="" assignTo="{!searchDate}"/>
</apex:commandButton>
</apex:panelGrid>
</apex:pageBlockSectionItem>
</apex:pageBlockSection> Here is a search method from my APEX controller:
public PageReference ViewData() {
string sortFullExp = sortExpression + ' ' + sortDirection;
if(searchText != null) {
searchstr = 'WHERE Name LIKE \'%' + searchText + '%\' order by ';}
if(searchDate != null) {
searchstr = 'WHERE Name LIKE \'%' + searchText + '%\' and CreatedDate =: searchDate order by ';}
items = Database.query('Select id, Name, Item_Price__c, CreatedDate from Item__c ' + searchstr + sortFullExp);
return null;
} ...and it doesn't work!!! =(
I guess that my issue concerns date formats both that entered when user adds new item and when searching one.
Help me please!
Thanks in advance.
