Skip to main content

Special Date Values for Filter Criteria


If you do a tabular report, you have the option of limiting it to the top 5.  You do this in the custom filter portion of the report design.

Here's all the special date filters -- copied from Online Help

Special Date Values for Filter Criteria
Available in: All Editions

Use the following special date values when defining filter criteria using dates. If you choose a date field (for example, Create Date, Last Update Date) as a filter criteria, the value can be a date in the format allowed by your Locale setting or any of the following special values:
Special Date ValueRange
YESTERDAYStarts at 12:00:00 a.m. on the day before the current day and continues for 24 hours.
TODAYStarts at 12:00:00 a.m. on the current day and continues for 24 hours.
TOMORROWStarts at 12:00:00 a.m. on the day after the current day and continues for 24 hours.
LAST WEEKStarts at 12:00:00 a.m. on the first day of the week before the current week and continues for seven days.
For Enterprise, Unlimited, Professional, and Developer Editions, 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 Contact Manager, Group, and Personal Editions, the week is defined by the Localesetting in the company profile at Your Name | Setup | Company Profile | Company Information. For example, when the Locale is US English, a week runs Sunday to Saturday, whereas with UK English, a week spans Monday to Sunday.
THIS WEEKStarts at 12:00:00 a.m. on the first day of the current week and continues for seven days.
For Enterprise, Unlimited, Professional, and Developer Editions, 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 Contact Manager, Group, and Personal Editions, the week is defined by the Localesetting in the company profile at Your Name | Setup | Company Profile | Company Information. For example, when the Locale is US English, a week runs Sunday to Saturday, whereas with UK English, a week spans Monday to Sunday.
NEXT WEEKStarts at 12:00:00 a.m. on the first day of the week after the current week and continues for seven days.
For Enterprise, Unlimited, Professional, and Developer Editions, 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 Contact Manager, Group, and Personal Editions, the week is defined by the Localesetting in the company profile at Your Name | Setup | Company Profile | Company Information. For example, when the Locale is US English, a week runs Sunday to Saturday, whereas with UK English, a week spans Monday to Sunday.
LAST MONTHStarts at 12:00:00 a.m. on the first day of the month before the current month and continues for all the days of that month.
THIS MONTHStarts at 12:00:00 a.m. on the first day of the current month and continues for all the days of that month.
NEXT MONTHStarts at 12:00:00 a.m. on the first day of the month after the current month and continues for all the days of that month.
LAST 90 DAYSStarts at 12:00:00 a.m. 90 days before the current day and continues up to the current second. (The range includes today.)
NEXT 90 DAYSStarts at 12:00:00 a.m. on the day after the current day and continues for 90 days. (The range does not include today.)
LAST n DAYSStarts at 12:00:00 a.m. n days before the current day and continues up to the current second. (The range includes today.)
NEXT n DAYSStarts at 12:00:00 a.m. on the next day and continues for the next n days. (The range does not include today.)
LAST QUARTERStarts 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 QUARTERStarts at 12:00:00 a.m. on the first day of the current quarter and continues to the end of the quarter.
NEXT QUARTERStarts at 12:00:00 a.m. on the first day of the quarter after the current quarter and continues to the end of that quarter.
LAST n QUARTERSStarts at 12:00:00 a.m. on the first day of the quarter n quarters ago and continues to the end of the quarter before the current quarter. (The range does not include the current quarter.)
NEXT n QUARTERSStarts at 12:00:00 a.m. on the first day of the quarter after the current quarter and continues to the end of the quarter nquarters in the future. (The range does not include the current quarter.)
LAST YEARStarts at 12:00:00 a.m. on January 1 of the year before the current year and continues through the end of December 31 of that year.
THIS YEARStarts at 12:00:00 a.m. on January 1 of the current year and continues through the end of December 31 of the current year.
NEXT YEARStarts at 12:00:00 a.m. on January 1 of the year after the current year and continues through the end of December 31 of that year.
LAST n YEARSStarts at 12:00:00 a.m. on January 1 of the year n years ago and continues through December 31 of the year before the current year.
NEXT n YEARSStarts at 12:00:00 a.m. on January 1 of the year after the current year and continues through the end of December 31 of the nth year.
LAST FISCAL QUARTERStarts at 12:00:00 a.m. on the first day of the fiscal quarter before the current fiscal quarter and continues through the last day of that fiscal quarter. The fiscal quarter is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year.
NOTE: None of the FISCAL special date values are supported when creating mobile custom views.
THIS FISCAL QUARTERStarts at 12:00:00 a.m. on the first day of the current fiscal quarter and continues through the end of the last day of the current fiscal quarter. The fiscal quarter is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year.
NEXT FISCAL QUARTERStarts at 12:00:00 a.m. on the first day of the fiscal quarter after the current fiscal quarter and continues through the last day of that fiscal quarter. (The range does not include the current quarter.) The fiscal quarter is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year.
LAST n FISCAL QUARTERSStarts at 12:00:00 a.m. on the first day of the fiscal quarter nfiscal quarters ago and continues through the end of the last day of the previous fiscal quarter. (The range does not include the current fiscal quarter.) The fiscal quarter is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year.
NEXT n FISCAL QUARTERSStarts at 12:00:00 a.m. on the first day of the fiscal quarter after the current fiscal quarter and continues through the end of the last day of the nth fiscal quarter. (The range does not include the current fiscal quarter.) The fiscal quarter is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year.
LAST FISCAL YEARStarts at 12:00:00 a.m. on the first day of the fiscal year before the current fiscal year and continues through the end of the last day of that fiscal year. The fiscal year is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year.
THIS FISCAL YEARStarts at 12:00:00 a.m. on the first day of the current fiscal year and continues through the end of the last day of the fiscal year. The fiscal year is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year.
NEXT FISCAL YEARStarts at 12:00:00 a.m. on the first day of the fiscal year after the current fiscal year and continues through the end of the last day of that fiscal year. The fiscal year is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year.
LAST n FISCAL YEARSStarts at 12:00:00 a.m. on the first day of the fiscal year n fiscal years ago and continues through the end of the last day of the fiscal year before the current fiscal year. (The range does not include the current fiscal year.) The fiscal year is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year.
NEXT n FISCAL YEARSStarts at 12:00:00 a.m. on the first day of the fiscal year after the current fiscal year and continues through the end of the last day of the nth fiscal year. (The range does not include the current fiscal year.) The fiscal year is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year.
For example, to create a custom view or report of accounts created last week, enter “Create Date equals LAST WEEK.” Date values are not case-sensitive; you can use “LAST WEEK” or “last week.” For special date values with variables (such as “NEXT N DAYS”), substitute N with any number greater than zero. Do not use commas.

Comments

  1. vanawaferMarch 3, 2022 at 1:16 PM

    Casino Review & Ratings | Dr.MCD
    The casino 속초 출장샵 is an easy to navigate casino with many different 경주 출장안마 game choices. Play 영천 출장마사지 for real money, try for 부산광역 출장마사지 free and enjoy exciting online gaming games. Rating: 4.4 · 속초 출장샵 ‎Review by Dr.MCD

    ReplyDelete

Post a Comment

Popular posts from this blog

How to create a custom button to open Visualforce page

Let's say that you are working in a large Org and different groups throughout the company use the same object, but each a little differently. Instead of overriding the standard "Edit" or "New" buttons, create a custom button. For example, there is a custom object on the standard Opportunity object and you want to launch a different page layout for your sales team for a custom quoting object. Create your "Quote" Visualforce page. Create the custom button on the custom object. Label: New API Name: New_Quote Type: List Button Content Source: OnClick JavaScript Behavior: Execute JavaScript Button or Link URL: window.open("/apex/InputVisualforcePageNameHere?RecordType=InputRecordTypeIdHere&retURL={!Opportunity.Id}&cancelURL={!Opportunity.Id}&saveURL={!Opportunity.Id}","_parent"); Edit the Opportunity page layout for the sales team and modify the buttons on the related list to add your custom button. In ...
Post a Comment
Read more

Replace the Salesforce.com logo with a company logo

Having the Salesforce.com logo in the top left of your Org can make it feel like you are using a tool that is not built for your company. Fortunately, there is an easy way to brand your Org with your company's logo. Follow these simple steps: Import the company logo Go to All Tabs > Documents. Select the "Documents" object and the "New" button. The document name will be something like "CompanyLogo.jpg". Set "Externally Available Image" as TRUE. Choose to place the record in either a custom Admin folder to separate from other document files or place it in your "My Personal Documents". Upload the file from your computer. I recommend that the image you attach be 200 pixels width, 45 pixels height, and no more than 20KB in size. Try to use an image with a transparent background since SFDC's background uses a gradient color scheme. Save. Create a custom App Go to Setup > Build > Create > Apps. Select ...
Post a Comment
Read more

How to Format Number or Currency Values in Conga (Word)

Formatting Number Values The number formatting parameter begins with \#, followed by any combination of the following parameters.  Please see the examples following this table. When Conga Composer populates a numeric value, the digit grouping symbol (the “thousands separator”) is defined according to your Locale settings (as defined in Salesforce’s Setup | Personal Information) or according to the Culture or CurrencyCulture Conga Composer parameter. Despite the cultural settings that govern the output from Conga Composer, within an appearance parameter, you must use a comma (",") for the digit grouping symbol (for thousands) and a period (".") as the decimal symbol. ​   PARAMETER DESCRIPTION 0 (zero) Specifies the requisite numeric places to display in the result. If the result does not include a digit in that place, Word displays a 0 (zero). Example: { = 4 + 5 \# 00.00 } displays "09.00". # Specifies the requisite numeric places to display in the r...
Post a Comment
Read more