+ Start a Discussion
Money CareMoney Care 

Formula field for Date filter

Hi All

Account object having more than 4k record from 2010 to till.i want the lastmodified date which created date not equal in 1/4/2015 to 31/3/2016.

one record which created date is 23/4/2010 and modified date is 28/4/2016 .how to find this record

Vivek DVivek D
Date dateOne = Date.newInstance('2015','2','1');
Date dateTwo = Date.newInstance('2016','3','31');

[ WHERE CreatedDate < :dateOne AND CreatedDate > :dateTwo) ]

Nitesh Gadkari 1Nitesh Gadkari 1

Most simplest way according to me would be to create a list view for account.There you can apply your filters and get the record.