Can I use 'last 6 months' in an Apex Data Loader extract?

Question

I want to make a regular extract of data using the Apex Data Loader based on creation date = in the last 6 months. I make a template of the query so it is quick to replicate each time I need to run the extract, so I don't want to have to select a date each time.  How do I do this in the Apex Data Loader, is it possible?

Sunil Sarilla · Accepted Answer

Hi Sara,

Your Query would like something below

SELECT Id, Name, (any other fields separated by comma) FROM ObjectAPIName WHERE CreatedDate = LAST_N_MONTHS:6

Everytime you extract the data you need to paste this Query in the Query Generator box.

Please refer to the following link for more info

Sara Monksfield · Answer

Thanks very much for your replies. I went with Sunil's suggestion because I'm sure I'm going to get asked to run the data for different timescales so this is easy to change.   I found that if I use MONTHS it only returns the previous completed month, so run near the end of September only included up to August.  I needed it to be a little more up to date so changed it to LAST_N_DAYS:180 for the perfect result.   Thanks again!

Can I use 'last 6 months' in an Apex Data Loader extract?

Reports & Dashboards

Aprendizaje relacionado

Más ayuda