So I created a Job that is supposed to run every day and give me a list of Opportunity records that have not been modified in the last 6 months, so I can email the owner and let him/her know that the status of that record will change to Closed Lost. When I'm writing the test class for this I'm running into an issue. I can not set the LastModifiedDate to 180 days ago. I've read and I was told that I can use Dependency Injection to put any date I want but I don't know how to do that, has anyone done it before? Do you have a sample code I could use? Thanks in advanced.

  • are you using Json.deserialize to create your mock data or test.loadData ?
    – cropredy
    Dec 31, 2015 at 0:07
  • No, I'm just using permission set to overwrite audit fields but it still won't work.
    – Leo
    Jan 4, 2016 at 21:00
  • @crop1645 I'm using Json.deserialize to create my mock data, I just can't insert it, I know I need to change my job now and check if I'm passing a list of Opps or not and create it if it's not there. Right?
    – Leo
    Jan 6, 2016 at 16:41
  • JSON.deserialize creates SObjects, not persisted SObjects; I'm not sure if via Apex Database.insert you can insert audit fields as the doc states it applies only to the API - and the API is not available in testmethods. I'm not sure I understand your question -- to test a batchable class invoked by Database.execute() that uses a start() queryLocator, you need to mock persistent data ..otherwise, you can test just the execute() method with sobjects created by JSON.deserialize (but this doesn;t test the start() method)
    – cropredy
    Jan 6, 2016 at 19:48

2 Answers 2


One way to create testdata with lastModifiedDate in the past is through Test.loadData()

Step 1- Create CSV File for your sobject

name    createdDate            lastmodifiedDate
00foo   2000-01-01T00:00:00Z    2001-01-01T00:00:00Z
01foo   2000-01-02T00:00:00Z    2001-01-02T00:00:00Z

Step 2 - save as Static Resource (named here as sfseLastModDateInPast)

Step 3 - Code test method

private static void testLastModDateInPast () {

    Foo__c[] fList = test.loadData(Foo__c.sObjectType,'sfseLastModDateInPast');


If your object has triggers then you'll want to disable before executing Test.loadData as otherwise the triggers may cause lastModifiedDate to be refreshed to now

If you need to create relationships in the static resource, use external IDs or see undocumented tip here

Debug output (truncated)

  10:34:13:261 USER_DEBUG [7]|INFO|(Foo__c:{
     CreatedDate=2000-01-01 00:00:00,  // in past
     LastModifiedDate=2001-01-01 00:00:00, // in past
     SystemModstamp=2016-01-02 18:34:09, ... )

I would just manipulate your QueryLocator.

public class MyBatch implements Database.Batchable<SObject>
    @TestVisible static String whereClause = 'WHERE LastModifiedDate < LAST_N_MONTHS:6';
    static final String soql = 'SELECT Id FROM Opportunity ' + whereClause;
    // other logic

Then in your test just change the clause to an empty string or whatever you like.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .