Classic file types are going away in December 2020 with the end of Flash. To avoid interruption, start transitioning your files to next gen. Learn More

XBRL error with Document Period End Date

Answered

Comments

8 comments

  • 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 Master 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
  • 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

    1
  • 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
  • Anna Zhu

    The second option works, thanks!

    0
  • Gaby Le

    Awesome; glad to help!

    0

Please sign in to leave a comment.