{"id":235391,"date":"2024-05-24T15:31:15","date_gmt":"2024-05-24T15:31:15","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=235391"},"modified":"2024-05-24T15:31:15","modified_gmt":"2024-05-24T15:31:15","slug":"how-to-get-date-in-pivot-table-value-field","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/","title":{"rendered":"How to get date in pivot table value field?"},"content":{"rendered":"<p><strong>To get a date in a pivot table value field, you first need to ensure that the column containing the dates in your data source is formatted as date. Then, simply drag the date field into the values area of the pivot table.<\/strong> This will display the dates in the pivot table as values, which can be summarized using functions like sum, count, average, etc.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#FAQs\" title=\"FAQs:\">FAQs:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#1_Can_I_use_text_values_in_the_value_field_of_a_pivot_table\" title=\"1. Can I use text values in the value field of a pivot table?\">1. Can I use text values in the value field of a pivot table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#2_How_can_I_group_dates_in_a_pivot_table\" title=\"2. How can I group dates in a pivot table?\">2. How can I group dates in a pivot table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#3_Can_I_format_the_dates_in_the_pivot_table_value_field\" title=\"3. Can I format the dates in the pivot table value field?\">3. Can I format the dates in the pivot table value field?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#4_Is_it_possible_to_filter_dates_in_the_value_field_of_a_pivot_table\" title=\"4. Is it possible to filter dates in the value field of a pivot table?\">4. Is it possible to filter dates in the value field of a pivot table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#5_How_can_I_change_the_summary_function_for_date_values_in_a_pivot_table\" title=\"5. How can I change the summary function for date values in a pivot table?\">5. How can I change the summary function for date values in a pivot table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#6_Can_I_show_dates_as_a_percentage_in_the_pivot_table_value_field\" title=\"6. Can I show dates as a percentage in the pivot table value field?\">6. Can I show dates as a percentage in the pivot table value field?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#7_How_can_I_customize_the_date_format_in_the_pivot_table_value_field\" title=\"7. How can I customize the date format in the pivot table value field?\">7. How can I customize the date format in the pivot table value field?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#8_Can_I_create_a_calculated_field_based_on_date_values_in_a_pivot_table\" title=\"8. Can I create a calculated field based on date values in a pivot table?\">8. Can I create a calculated field based on date values in a pivot table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#9_How_can_I_sort_date_values_in_the_pivot_table_value_field\" title=\"9. How can I sort date values in the pivot table value field?\">9. How can I sort date values in the pivot table value field?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#10_Can_I_use_date_ranges_in_the_value_field_of_a_pivot_table\" title=\"10. Can I use date ranges in the value field of a pivot table?\">10. Can I use date ranges in the value field of a pivot table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#11_How_can_I_display_date_values_as_running_totals_in_a_pivot_table\" title=\"11. How can I display date values as running totals in a pivot table?\">11. How can I display date values as running totals in a pivot table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#12_Is_it_possible_to_calculate_differences_between_date_values_in_a_pivot_table\" title=\"12. Is it possible to calculate differences between date values in a pivot table?\">12. Is it possible to calculate differences between date values in a pivot table?<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQs:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"1_Can_I_use_text_values_in_the_value_field_of_a_pivot_table\"><\/span>1. Can I use text values in the value field of a pivot table?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>No, the value field in a pivot table is typically used for numerical data such as dates, currencies, percentages, etc. Text values are usually placed in the rows or columns areas for grouping and filtering.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_How_can_I_group_dates_in_a_pivot_table\"><\/span>2. How can I group dates in a pivot table?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To group dates in a pivot table, simply right-click on a date value in the pivot table, select &#8220;Group&#8221;, and then choose the desired grouping option such as by month, quarter, or year.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Can_I_format_the_dates_in_the_pivot_table_value_field\"><\/span>3. Can I format the dates in the pivot table value field?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, you can format the dates in the value field of a pivot table by right-clicking on a date value, selecting &#8220;Number Format&#8221;, and then choosing the desired date format from the list.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Is_it_possible_to_filter_dates_in_the_value_field_of_a_pivot_table\"><\/span>4. Is it possible to filter dates in the value field of a pivot table?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, you can filter dates in the value field of a pivot table by clicking on the filter dropdown menu next to the date field, and then selecting the desired date range or specific dates to display.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_How_can_I_change_the_summary_function_for_date_values_in_a_pivot_table\"><\/span>5. How can I change the summary function for date values in a pivot table?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To change the summary function for date values in a pivot table, you can right-click on a date value in the pivot table, select &#8220;Value Field Settings&#8221;, and then choose a different function such as average, minimum, maximum, etc.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Can_I_show_dates_as_a_percentage_in_the_pivot_table_value_field\"><\/span>6. Can I show dates as a percentage in the pivot table value field?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>No, dates are typically displayed as numerical values in the value field of a pivot table. If you want to show dates as percentages, you may need to calculate the percentage based on the date values and display the result in a separate calculated field.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_How_can_I_customize_the_date_format_in_the_pivot_table_value_field\"><\/span>7. How can I customize the date format in the pivot table value field?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To customize the date format in the pivot table value field, you can right-click on a date value, select &#8220;Number Format&#8221;, and then choose the custom date format option to specify the desired format for displaying dates.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_Can_I_create_a_calculated_field_based_on_date_values_in_a_pivot_table\"><\/span>8. Can I create a calculated field based on date values in a pivot table?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, you can create a calculated field based on date values in a pivot table by selecting &#8220;Insert&#8221; on the pivot table toolbar, choosing &#8220;Calculated Field&#8221;, and then entering the formula that references the date fields.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_How_can_I_sort_date_values_in_the_pivot_table_value_field\"><\/span>9. How can I sort date values in the pivot table value field?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To sort date values in the pivot table value field, you can right-click on a date value, select &#8220;Sort&#8221;, and then choose the desired sorting order such as ascending or descending based on the dates.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_Can_I_use_date_ranges_in_the_value_field_of_a_pivot_table\"><\/span>10. Can I use date ranges in the value field of a pivot table?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, you can use date ranges in the value field of a pivot table by applying filters to restrict the date values displayed in the pivot table based on specific ranges or criteria.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_How_can_I_display_date_values_as_running_totals_in_a_pivot_table\"><\/span>11. How can I display date values as running totals in a pivot table?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To display date values as running totals in a pivot table, you can use the &#8220;Show Values As&#8221; option in the pivot table toolbar and select the running total calculation to show the cumulative totals for the date values.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Is_it_possible_to_calculate_differences_between_date_values_in_a_pivot_table\"><\/span>12. Is it possible to calculate differences between date values in a pivot table?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, you can calculate the differences between date values in a pivot table by creating a calculated field that subtracts one date value from another, allowing you to analyze the time intervals between dates in the pivot table.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To get a date in a pivot table value field, you first need to ensure that the column containing the dates in your data source is formatted as date. Then, simply drag the date field into the values area of the pivot table. This will display the dates in the pivot table as values, which &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to get date in pivot table value field?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#more-235391\">Read more<span class=\"screen-reader-text\">How to get date in pivot table value field?<\/span><\/a><\/p>\n","protected":false},"author":59,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-235391","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to get date in pivot table value field?<\/title>\n<meta name=\"description\" content=\"To get a date in a pivot table value field, you first need to ensure that the column containing the dates in your data source is formatted as date. Then,\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to get date in pivot table value field?\" \/>\n<meta property=\"og:description\" content=\"To get a date in a pivot table value field, you first need to ensure that the column containing the dates in your data source is formatted as date. Then,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-24T15:31:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Francis French\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Francis French\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/\"},\"author\":{\"name\":\"Francis French\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48\"},\"headline\":\"How to get date in pivot table value field?\",\"datePublished\":\"2024-05-24T15:31:15+00:00\",\"dateModified\":\"2024-05-24T15:31:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/\"},\"wordCount\":667,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/\",\"name\":\"How to get date in pivot table value field?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-05-24T15:31:15+00:00\",\"dateModified\":\"2024-05-24T15:31:15+00:00\",\"description\":\"To get a date in a pivot table value field, you first need to ensure that the column containing the dates in your data source is formatted as date. Then,\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to get date in pivot table value field?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48\",\"name\":\"Francis French\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Francis French\"},\"description\":\"Guest author Francis French has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to get date in pivot table value field?","description":"To get a date in a pivot table value field, you first need to ensure that the column containing the dates in your data source is formatted as date. Then,","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/","og_locale":"en_US","og_type":"article","og_title":"How to get date in pivot table value field?","og_description":"To get a date in a pivot table value field, you first need to ensure that the column containing the dates in your data source is formatted as date. Then,","og_url":"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-05-24T15:31:15+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png","type":"image\/png"}],"author":"Francis French","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Francis French","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/"},"author":{"name":"Francis French","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48"},"headline":"How to get date in pivot table value field?","datePublished":"2024-05-24T15:31:15+00:00","dateModified":"2024-05-24T15:31:15+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/"},"wordCount":667,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/","url":"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/","name":"How to get date in pivot table value field?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-05-24T15:31:15+00:00","dateModified":"2024-05-24T15:31:15+00:00","description":"To get a date in a pivot table value field, you first need to ensure that the column containing the dates in your data source is formatted as date. Then,","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-date-in-pivot-table-value-field\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to get date in pivot table value field?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48","name":"Francis French","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Francis French"},"description":"Guest author Francis French has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/235391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/59"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=235391"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/235391\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=235391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=235391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=235391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}