I am trying to copy the last 3 years data from the SalesForce Datasource to my local Database by using 'Createddate>   LAST_N_YEARS:4'. It is not fetching any data older than Jan 1st 2012. I was wondering if SalesForce archive the last year's data.

I am new to Salesforce coding.

How can i replicate this scenario in Microsoft sql " select * form table where modifieddate >= getdate() - 1" Salesforce coding??

Thanks for your help in advance.