I tipi di file classici non potranno più essere utilizzati a partire da gennaio 2021. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

XBRL error with Document Period End Date

Con risposta
0

Commenti

8 commenti

  • 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

Accedi per aggiungere un commento.