Manage Date Functions (Version 2)
Application component: Date Function
App type: Transactional
Description:  You use this app to view predefined (by SAP) and to create user-defined date functions. This app determines a single date or a date range using base and relative dates. The result displayed is the difference between the base and the relative date. The date functions that you create are categorized as Custom. From the Manage Date Functions page, you can view, search, and delete the customized date functions. The Search field allows you to search for a date function. You can search for multiple date functions using *.  To view the predefined date functions, choose the arrow button next to the selected date function.  To create a new date function, choose Add. For more details, see Creating a Date Function. 
Key features: The predefined date functions display the date function name, description, date function type whether single or date range, the base date, relative date, and the result under Simulated Date section. This section displays both the server-based and the user-based dates.  Server-Based: Often, database servers run in UTC. The date displayed is the datestamp based on the server’s timezone.   User-Based: The date displayed is the datestamp based on user’s timezone maintained in the Maintain Business Users app.   More details on base date and relative date, and the date calculations is as follows:Base DateThe base date is the reference date for the date calculation. These are some examples of base dates:  Today   Yesterday   First Day of Previous Week Previous Year   Custom (You can enter a specific date using the calendar option)  If you have selected the option Today, then the base date is the current date of the specified server or the local system. For example, if the current date in the local system or the server is 2/27/2017 and if you choose the base date as First Day of Previous Week Previous Year, then 02/15/2016 is displayed.Relative DateThe relative date is the date range that is relative to the base date.Some examples of relative date conditions are:   4 weeks ago   3 quarters from now  The result displays the date range that is calculated based on the base date and the relative date. The dates can be earlier or later dates with the base date as the reference point. For example, if the base date is 2/28/2017 and the relative date is Last Day of Current Week Next Year, then the simulated date range is 02/28/2017 - 03/04/2018.New date configurations From Today, From First Day of, and From Last Day of are available in base and relative date fields. The configurations are available in the Base Date field when you choose the Single Date function type and are available in both the Base Date and Relative Date fields when you choose Relative Date Type  Configured. The result displayed is the date range that is calculated based on the base date and relative date.  Creating a Date Function The Add button allows you to create a date function based on the specified base and relative date. In the New Date Function screen, you must enter the following:  Define Date Parameters All IDs must beging with Z, Y, or YY_1. The prefix IDs are filled depending on system configuration. You maintain the name and the description for the date function. The name and the description can be maintained in additional languages. The Maintain Languages field allows you to create the date function in multiple languages where you select a language from the drop-down list, provide a name, and an optional description. The number within the parenthesis is the count of the added languages. You can also delete the language, name, and description using the delete icon that is available next to each row.    Date Function Type: Choose option Single or Range.  Single Returns a single date in the format MM/DD/YYYY based on the base date selection. Choose a date format from the Base Date field. The date function calculates the date based on the system date and the selected date in the Base Date field.  For example, if the current date in the system is 2/27/2017 and you choose Yesterday as the base date, the result is 2/26/2017.   Range  Relative to Base Date: You can select a base date, and enter an integer as the relative date. The date range displayed can be in the past or a later date range with the base date as the reference date. The options for the relative date are Days, Weeks, Months, Years, and Quarters. For example, if the base date is 2/27/2017 and the Relative to Base Date is 4 days later, the result is 02/23/2017 - 02/27/2017.   Configured: You can configure the dates for Base and Relative date. The result is the date range that is between the base date and the relative date.  For example, if the base date is Today and relative date is First Day of Previous Week Previous Year, the result date range is 02/15/2016 - 02/28/2017.       Edit/Delete customized date functions You can edit the title and the description of the customized date functions using Edit button. Choose Delete to delete the customized date function.   
Business roles: Analytics Specialist
Analytics Specialist : 
Designs analytical queries and reports by using analytics tools.