Results 1 to 4 of 4

Thread: Pivot table date Format Mismatch
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot table date Format Mismatch

    Dear All


    I extracted website data for a specified time period from Tool1 & Tool2 and try to compare date wise report between two tools Via Pivot table. But the date format is not matching between the tool even though the date format is same (YYYYMMDD) 20190201. How to sync the dates of different tools in Pivot table. Pls. find attached the excel sheet with pivot table for your kind reference. I am unable to attach the excel. That is the reason i pasted the pivot table here. Pls. Help

    Row Labels 20190201 20190202 20190203 20190204 20190205 20190206 20190207 20190208 20190209 20190210 20190211 20190212 20190213 20190214 20190215 20190216 20190217 20190218 20190219 20190301 20190302 20190303 20190304 20190305 20190306 20190307 20190308 20190309 20190310 20190311 20190312 20190313 20190314 20190315 20190316 20190317 20190318 20190319
    Website1 771 704 663 630 615 668 596 1064 1174 1313 1568 1346 1506 2148 1711 1619 1732 1776 1634 1550 1176 1412 1217 1403 1419 1338 1260 1305 1227 1425 1424 1267 1296 1083 1312 1290 1332 1446
    Tool1 1550 1176 1412 1217 1403 1419 1338 1260 1305 1227 1425 1424 1267 1296 1083 1312 1290 1332 1446
    Tool2 771 704 663 630 615 668 596 1064 1174 1313 1568 1346 1506 2148 1711 1619 1732 1776 1634
    Grand Total 771 704 663 630 615 668 596 1064 1174 1313 1568 1346 1506 2148 1711 1619 1732 1776 1634 1550 1176 1412 1217 1403 1419 1338 1260 1305 1227 1425 1424 1267 1296 1083 1312 1290 1332 1446

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,012
    Post Thanks / Like
    Mentioned
    467 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Pivot table date Format Mismatch - Pls.Help

    Hi & welcome to MrExcel.
    Cross posted on multiple sites.

    While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
    This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

    Please supply links to all other sites where you have asked this question.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    New Member
    Join Date
    Mar 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot table date Format Mismatch - Pls.Help

    HI Fluff

    I posted the same query in multiple forum in need of solution. I don't have any intention to spam the forum. My query is genuine. I future i don't do so. This is my first post. Pls. provide me a solution for my problem. Hope you understood my problem. Pls. give solution to my problem. Thanks

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,012
    Post Thanks / Like
    Mentioned
    467 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Pivot table date Format Mismatch - Pls.Help

    You need to supply the links to all other sites where you have asked this question.
    Please do so.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •