function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SFDBadminSFDBadmin 

I need help with saving a report to reflecty a constant 6 month period

I am looking for help on how to have a report be saved for a six month period. Meaning that if today is 8-2-2010 the report reflect the last 6 month period Feb 2 2010 to 8-2-2010. When we are at 8-30-2010 the report reflects 2-30-2010 to 8-30-2010.

 

Thank you

Best Answer chosen by Admin (Salesforce Developers) 
Ispita_NavatarIspita_Navatar

From your query it appears that you wish to specify a criterion whcih enables you to generate a report over a time period of

LAST 6 MONTHS

 

Please refer to the following URL for this type of expressions which can be used in a Date field used for setting filter criteria.

https://na6.salesforce.com/help/doc/en/custom_dates.htm  --> use this URL when you are logged in in your ORG.

 

For example use these expresssions in report's filter criterion :-          

                                       Target date equals LAST MONTH

                                       Target date equals LAST 183 DAYS {whcih is in a way last six months}

 

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


All Answers

Ispita_NavatarIspita_Navatar

From your query it appears that you wish to specify a criterion whcih enables you to generate a report over a time period of

LAST 6 MONTHS

 

Please refer to the following URL for this type of expressions which can be used in a Date field used for setting filter criteria.

https://na6.salesforce.com/help/doc/en/custom_dates.htm  --> use this URL when you are logged in in your ORG.

 

For example use these expresssions in report's filter criterion :-          

                                       Target date equals LAST MONTH

                                       Target date equals LAST 183 DAYS {whcih is in a way last six months}

 

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


This was selected as the best answer
SFDBadminSFDBadmin

Thank you Ispita.

 

Can you help me with this?

 

I cannot figure out how to pull up this kind of list view. Where do I startt? The example link is for a custom object called "Timeline Template"
http://content.screencast.com/users/pauldes/folders/Jing/media/a1182d6f-0e34-482b-ae26-2f67d494237b/2010-08-02_1234.png

Can you help me with this?

Thank you,

 

Jami

Ispita_NavatarIspita_Navatar

do you have this custom object called :-

1) "Timeline Template" ?

 

2) did u assign a tab to it?

 

3) Are not able to create this view , or not able to find this view?

SFDBadminSFDBadmin

Ispita,

 

Thank you. I new it was something simple. Needed to assign tab.

 

Do you do any training for admins? I am still on a learning curve for workflow rules, formulas, and more advanced reporting.

Or what is the best way when I post things that you can help and get the credit?

 

Still new at this.

 

Jami