Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

XBRL error with Document Period End Date

Answered
Request Demo
Just transitioned to the 2019 DEI taxonomy for our Q3 10-Q and transitioned our workbook to sheets.  As a result, I now have an error with the document period end date: previously it had been linked from our workbook, but the value came back in MS Excel format (i.e. "43738"), so I removed the link and changed it to "September 30, 2019."  However, now I'm getting an error that states that the fact value does not match the data type (date), even though the data type is set to "Date."  And when I click on the fact properties, it states that there is no information available.  This error did not occur in our Q2 10-Q.  Thanks!
0

Comments

8 comments

Date Votes
  • Gaby Le

    Fellow Wdesk user here - I believe the error you're seeing is due to the formatting of the date - see our example attached. The format should be in the mm/dd/yyyy in the source (fx box), but you can right click on the cell, click on Format cells and choose Date and how you would like the date to appear. From what I'm reading, it appears your "September 30, 2019" date might currently be in Text format - once you change it to 9/30/2019 and date format hopefully that will resolve your error.

    Best,
    Gaby

    0
  • Gabe M

    It looks like that worked!  Thanks so much!

    0
  • Mike

    Way to go Gaby!

    0
  • Gaby Le

    Awesome; glad I was able to help!

    0
  • Anna Zhu

    Hi, I have the same issue as well. Is there a way I can change the MS Excel format (i.e. "43738") back to the date format (9/30/2019) in spreadsheet? So that I don't have to create a source link in the document.

    0
  • Gaby Le

    Hey Anna,

    I'm guessing you have already tried adjusting the value formatting in the source cell to "Date"? (see screenshot)

    Another trick I can think of is to put the date in a different cell (in my example, cell D6 has a formula that references our Primary Dates tab), then in my source link cell I use the formula =TEXT(D6, "MM/DD/YYYY") - I wonder if that would do the trick for you?

    2
  • Anna Zhu

    The second option works, thanks!

    0
  • Gaby Le

    Awesome; glad to help!

    0

Please sign in to leave a comment.