CSV Data Link - Date is ########

[tim.mcc]

I have a CSV data link that includes a date. The date is correct in the CSV file, but when you open with Excel, the column is too narrow and it displays as "########". For some reason, my data link is bringing in that instead of the date value "10/23/2023".

- I checked the CSV file in notepad, and the date is correct.

- I can see the date when I open it in Excel and expand the column.

- The AutoCAD column has plenty of room for the date

Is there a way to fix this so my AutoCAD table actually displays the date value?

[Valentin-WSP]

@tim.mcc ,

Consider posting the drawing.

Also, see if changing the table width in your Properties helps.

[tim.mcc]

@Valentin-WSP  I attached the dwg, but it won't let me upload the CSV file. Here is what it looks like:

Tried increasing the table width too. The column should have plenty of space to display the date.

[Valentin-WSP]

@tim.mcc ,

Paste the CSV information on notepad and save as a *.txt file. Then make sure its the same name "#SSI_Drawing_List" and change the extension from *.txt to *.csv.  You should get this balloon in AutoCAD that the "Data Link Has Changed" - update and see it change.

[pendean]

---

@tim.mcc wrote:

@Valentin-WSP  I attached the dwg, but it won't let me upload the CSV file....

---

You can always ZIP files to share/post here too.

[TheCADnoob]

The more I poke at this, the more I'm confused. It almost feels like a bug, but I'm not sure where the problem lies. 

For the time being, if you feed the table a formula, the problems seem to go away. So if you change your data to be a table formula ="10/10/2023" it will put that into the csv it will get you down the road. 

That said, I can duplicate your problem (AutoCAD S.51.0.0 2022). What odd is that it seems like its an error when importing the data into AutoCAD. It seems like its trying to guess the datatype but fails if the month or day of the American date format is a two digit number (mm/dd/yyyy).

If you put the date 1/1/2023 does it format it properly?

[tim.mcc]

@TheCADnoob  I was able to get 2 conditions to work:

1. Single month + Single Day

2. Using periods instead of /

[TheCADnoob]

Using periods might be the easiest work around. 

What version of AutoCAD are you using?

I'm going to have to try this on another version of AutoCAD and see if it makes a difference. 

[tim.mcc]

I'm running AutoCAD 2023

[tim.mcc]

@Valentin-WSP Doing a SaveAs to .txt and then renaming the extension back to .csv worked with a small test file.

It did not work for the production file unfortunately.

Attached is a zip file with the dwg and linked csv (Thanks @pendean !)

[TheCADnoob]

---

@tim.mcc wrote:
I'm running AutoCAD 2023

---

I verified the behavior on something newer than 2023 as well as 2021 (cant get csv in web based AutoCAD)