+ Start a Discussion
SFDC0539SFDC0539 

Access createddate in query

Hi,

 

 

My requirement is to generate a visual force report based on lead created date. I need to take the created date as input and use it in the query to get only those records which were created on that date.

 

I am able to get it into the controller but unable to use it in the query. Please help......

 

 

 

Thanks...........

Navatar_DbSupNavatar_DbSup

Hi,

 

When you are using the input from the Vf page format of the input will be text. Before using that you have to parse the date into the date/date time format

 

Use the below code sample as reference

 

String datevalue=’01/1/2012’;
string[] mydate=datevalue.split('/');
system.debug('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!-->'+mydate);
integer year=integer.valueOf(mydate[2]);
integer month=integer.valueOf(mydate[1]);
integer day=integer.valueOf(mydate[0]);
Datetime GMTDate = Datetime.newInstanceGmt(year,day,month,0,0,0);
string strConvertedDate= GMTDate.format('yyyy-MM-dd\'T\'hh:mm:ss\'Z\'');

list< lead >uu=[select id,name from lead where createddate <: strConvertedDate];

 

Or

 

String datevalue=’01/1/2012’;
datetime dd=date.parse(value)
string strConvertedDate=dd.format('yyyy-MM-dd\'T\'hh:mm:ss\'Z\'');
list< lead >uu=[select id,name from lead where createddate <: strConvertedDate];

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.