Upload System Names to Run Report on Saleforce

Easy Peasy Appointment Filters in Salesforce Reports

Do you lot need to run reports that show records that have 2 relative appointment filters?

Say, all contacts that were created terminal twelvemonth AND whose feedback engagement was final year?

It's simple to filter reports by one appointment field. Use the Appointment Field driblet down in the filter section of the report editor and cull your relative Date Range.

Merely if y'all want to filter on some other date you need to add a new filter which doesn't give you the Date Range drop-down.  Luckily Salesforce allows you to type in the same ranges using "special engagement values".  And so y'all can add a filter field and select the other engagement field and type the relative value in the spot where you would normally put i date.

Here is a list of all the relative date values you lot tin type in:

*notation that the values are non case-sensitive and you can substitute the variable ("Side by side Due north DAYS") with any number greater than 0

Special Date Value	Range
YESTERDAY	Starts at 12:00:00 a.m. on the day before the electric current day and continues for 24 hours.
TODAY	Starts at 12:00:00 a.m. on the current day and continues for 24 hours.
TOMORROW	Starts at 12:00:00 a.m. on the 24-hour interval after the current day and continues for 24 hours.
Final WEEK	Starts at 12:00:00 a.1000. on the first day of the week before the current week and continues for seven days. The week is defined by the Locale drop-down list in your personal information settings at Your Name | Setup | My Personal Information | Personal Information . For example, when the Locale is US English language, a week runs Sun to Saturday, whereas with Uk English, a week spans Monday to Sunday.
THIS Week	Starts at 12:00:00 a.m. on the beginning mean solar day of the current week and continues for seven days. The week is divers by the Locale drop-down list in your personal data settings at Your Proper name | Setup | My Personal Information | Personal Information . For example, when the Locale is US English, a calendar week runs Sunday to Saturday, whereas with United kingdom English, a week spans Monday to Sunday.
Next WEEK	Starts at 12:00:00 a.m. on the start solar day of the calendar week afterward the current week and continues for 7 days. The week is defined by the Locale drop-downwardly list in your personal data settings at Your Name | Setup | My Personal Information | Personal Information. For instance, when the Locale is U.s.a. English, a calendar week runs Sunday to Sabbatum, whereas with UK English, a week spans Mon to Lord's day.

Month

Terminal Month	Starts at 12:00:00 a.k. on the beginning day of the month earlier the electric current month and continues for all the days of that month.
THIS MONTH	Starts at 12:00:00 a.m. on the first day of the electric current month and continues for all the days of that month.
Adjacent Calendar month	Starts at 12:00:00 a.m. on the offset twenty-four hours of the month subsequently the current month and continues for all the days of that month.

Day

Terminal 90 DAYS	Starts at 12:00:00 a.chiliad. 90 days before the current mean solar day and continues up to the current second. (The range includes today.)
NEXT 90 DAYS	Starts at 12:00:00 a.m. on the 24-hour interval subsequently the electric current day and continues for 90 days. (The range does not include today.)
LAST north DAYS	Starts at 12:00:00 a.m. n days before the current day and continues up to the electric current second. (The range includes today.)
Adjacent n DAYS	Starts at 12:00:00 a.m. on the next day and continues for the next north days. (The range does not include today.)

Quarter

Concluding QUARTER	Starts at 12:00:00 a.m. on the first day of the quarter before the current quarter and continues to the end of that quarter.
THIS QUARTER	Starts at 12:00:00 a.thousand. on the first day of the current quarter and continues to the stop of the quarter.
NEXT QUARTER	Starts at 12:00:00 a.m. on the start day of the quarter later on the current quarter and continues to the cease of that quarter.
LAST northward QUARTERS	Starts at 12:00:00 a.grand. on the commencement day of the quarter n quarters ago and continues to the finish of the quarter before the electric current quarter. (The range does not include the current quarter.)
Next n QUARTERS	Starts at 12:00:00 a.m. on the beginning day of the quarter afterwards the current quarter and continues to the end of the quarter north quarters in the future. (The range does not include the current quarter.)

Twelvemonth

Terminal YEAR	Starts at 12:00:00 a.m. on January 1 of the twelvemonth before the current year and continues through the end of Dec 31 of that year.
THIS YEAR	Starts at 12:00:00 a.yard. on Jan 1 of the current year and continues through the end of Dec 31 of the electric current year.
Side by side YEAR	Starts at 12:00:00 a.m. on January one of the twelvemonth after the current yr and continues through the end of December 31 of that year.
LAST n YEARS	Starts at 12:00:00 a.m. on January 1 of the yr northward years agone and continues through December 31 of the year before the electric current year.
NEXT north YEARS	Starts at 12:00:00 a.g. on January i of the twelvemonth after the electric current year and continues through the end of December 31 of the nthursday twelvemonth.

Fiscal Quarter

LAST Fiscal QUARTER	Starts at 12:00:00 a.chiliad. on the outset 24-hour interval of the fiscal quarter before the current financial quarter and continues through the last solar day of that financial quarter. The fiscal quarter is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year.
THIS Fiscal QUARTER	Starts at 12:00:00 a.m. on the beginning twenty-four hour period of the current fiscal quarter and continues through the end of the concluding day of the current financial quarter. The financial quarter is defined in the company profile at Your Proper noun | Setup | Visitor Profile | Fiscal Year.
NEXT Financial QUARTER	Starts at 12:00:00 a.m. on the first solar day of the fiscal quarter after the electric current financial quarter and continues through the concluding twenty-four hour period of that fiscal quarter. (The range does non include the current quarter.) The financial quarter is defined in the company profile at Your Name | Setup | Visitor Profile | Fiscal Year .
LAST n Financial QUARTERS	Starts at 12:00:00 a.1000. on the first 24-hour interval of the fiscal quarter n fiscal quarters ago and continues through the terminate of the last day of the previous financial quarter. (The range does not include the current fiscal quarter.) The fiscal quarter is defined in the visitor profile at Your Name | Setup | Visitor Profile | Fiscal Yr.
Next n FISCAL QUARTERS	Starts at 12:00:00 a.yard. on the first twenty-four hours of the fiscal quarter after the current financial quarter and continues through the terminate of the final twenty-four hour period of the northth fiscal quarter. (The range does not include the electric current fiscal quarter.) The fiscal quarter is divers in the company profile at Your Name | Setup | Company Contour | Financial Twelvemonth .

Fiscal Yr

Concluding Fiscal Twelvemonth	Starts at 12:00:00 a.g. on the outset twenty-four hours of the fiscal year before the current fiscal year and continues through the end of the last day of that fiscal year. The fiscal twelvemonth is defined in the company contour at Your Name | Setup | Company Profile | Fiscal Year.
THIS Fiscal Twelvemonth	Starts at 12:00:00 a.grand. on the first twenty-four hours of the electric current fiscal yr and continues through the end of the last day of the fiscal year. The fiscal twelvemonth is defined in the visitor profile at Your Proper noun | Setup | Company Profile | Fiscal Yr.
NEXT FISCAL Yr	Starts at 12:00:00 a.m. on the offset day of the fiscal year after the current financial yr and continues through the end of the last mean solar day of that financial year. The fiscal year is defined in the company profile at Your Name | Setup | Visitor Contour | Fiscal Year.
Concluding north FISCAL YEARS	Starts at 12:00:00 a.m. on the first day of the fiscal year n fiscal years ago and continues through the finish of the last mean solar day of the fiscal twelvemonth before the current fiscal year. (The range does not include the current fiscal year.) The financial year is divers in the company profile at Your Name | Setup | Company Profile | Fiscal Yr.
NEXT north Fiscal YEARS	Starts at 12:00:00 a.k. on the offset twenty-four hours of the fiscal year after the current fiscal year and continues through the end of the last solar day of the northth fiscal year. (The range does non include the current fiscal year.) The fiscal yr is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year .

Check out the list of relative date filters from Salesforce cognition base!

ayersaring1975.blogspot.com

Source: https://www.sputnikmoment.com/easy-peasy-date-filters-salesforce-reports/

Share this post