--- schema_version: "1" id: edd8cdff656fa3df1142a1fe63c4775f3c1052d1767d0339186fb8c12d38e4ca title: Handle Date Values collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_date_generation.md canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_date_generation.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: c7c00efef42cf66a9c71b98383eb41b2bc2eb051095554ea34285f1b61fa3004 description: When CRM Analytics loads dates into a dataset, it breaks up each date into multiple columns, such as day, week, month, quarter, and year, based on the calendar year. For example, if you extract dates from a CreateDate column, CRM Analytics generates columns such as CreateDate_Day and CreateDate_Week. If your fiscal year differs from the calendar year, you can enable CRM Analytics to generate fiscal date columns as well. products: - CRM Analytics - Cross Cloud release: "264" --- # Handle Date Values When CRM Analytics loads dates into a dataset, it breaks up each date into multiple columns, such as day, week, month, quarter, and year, based on the calendar year. For example, if you extract dates from a `CreateDate` column, CRM Analytics generates columns such as `CreateDate_Day` and `CreateDate_Week`. If your fiscal year differs from the calendar year, you can enable CRM Analytics to generate fiscal date columns as well. ## Standard Date Fields CRM Analytics generates the following date columns. | Field Name | Field Type | Description | | --- | --- | --- | | \_Second | Text | Number of seconds. If the date contains no seconds, value is 0. | | \_Minute | Text | Number of minutes. If the date contains no minutes, value is 0. | | \_Hour | Text | Number of hours. If the date contains no hours, value is 0. | | \_Day | Text | Day of the month. | | \_Week | Text | Week number in calendar year. | | \_Month | Text | Month number in calendar year. | | \_Quarter | Text | Quarter number in calendar year. | | \_Year | Text | Calendar year. | | \_Week\_Fiscal | Text | Week number in fiscal year. | | \_Month\_Fiscal | Text | Month number in fiscal year. | | \_Quarter\_Fiscal | Text | Quarter number in fiscal year. | | \_Year\_Fiscal | Text | Fiscal year. | | \_sec\_epoch | Numeric | Number of seconds that have elapsed since January 1, 1970 (midnight UTC). | | \_day\_epoch | Numeric | Number of days that have elapsed since January 1, 1970 (midnight UTC). | ## Inherited Custom Fiscal Years Fields After you have defined a custom fiscal year in Salesforce and enabled the setting in CRM Analytics (see [Custom Fiscal Year Support](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_custom_fiscal_year.htm&release=264.0.0&type=5 "If your company uses a custom fiscal year, and has defined the custom fiscal year in Salesforce, then CRM Analytics can inherit the custom fiscal year definition from Salesforce. Once inherited, the custom fiscal year is available for use throughout CRM Analytics. For example, a dashboard filter can return opportunities from this fiscal quarter.")), have CRM Analytics inherit the custom fiscal year so your users can work with custom fiscal year data in SAQL queries and dashboards. When CRM Analytics loads dates into a dataset as part of a dataflow, it generates multiple fields that describe periods of time, such as day, week, and month. For example, when CRM Analytics loads a date field called `CreatedDate`, it generates fields like `CreatedDate_Day`, `CreatedDate_Week`, and `CreatedDate_Month`. After CRM Analytics inherits custom fiscal years from Salesforce, CRM Analytics generates more fields that describe the inherited custom fiscal years. The custom fiscal year fields are named with the suffix `_Fiscal`. Continuing with the `CreatedDate` example, CRM Analytics generates fields like `CreatedDate_Week_Fiscal`, `CreatedDate_Month_Fiscal`, and `CreatedDate_Quarter_Fiscal`. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png) Note If CRM Analytics custom fiscal years were previously defined using the standard fields (not inherited), then those fields are overwritten with data inherited from the custom fiscal years defined in Salesforce. Here are the Fiscal fields CRM Analytics generates for each date field. | Field Name | Field Type | Description | | --- | --- | --- | | \_Week\_Fiscal | Text | Week number in fiscal year. | | \_Month\_Fiscal | Text | Month number in fiscal year. | | \_Quarter\_Fiscal | Text | Quarter number in fiscal year. | | \_Year\_Fiscal | Numeric | Fiscal year. | - **[Considerations for Date Columns](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_date_column_considerations.htm&release=264.0.0&type=5)** Confirm that date values in a column are uniform in format and time zone. Inconsistencies can occur within a data source and after merging data from multiple data sources. - **[Date Formats and Fiscal Dates for Source Data](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_date_formats_and_fiscal_dates.htm&release=264.0.0&type=5)** You can set metadata attributes to control how dates are loaded into CRM Analytics and to enable CRM Analytics to generate fiscal date columns.