DATE CELL IN TABLE

DATE CELL IN TABLE

Anonymous
Not applicable
2,324 Views
8 Replies
Message 1 of 9

DATE CELL IN TABLE

Anonymous
Not applicable

I want to know how to link a cell from the autocad table to another cell in the autocad table because when I put a date (xx / xx / xxxx) the append appears in decimal format although I select the date format in destination cell. Sorry for my English :(.

Thanks

0 Likes
2,325 Views
8 Replies
Replies (8)
Message 2 of 9

pendean
Community Legend
Community Legend
FIELD command: explore it in HELP.
0 Likes
Message 3 of 9

TheCADnoob
Mentor
Mentor

I believe the problem is when you use the "cell" formula (i.e. =C2) it evaluates the date. so a date like 5/9/2017 is seen as a division problem and gets evaluated down to .0000275. 

 

The field expression "%<\AcExpr (C2)>%" looks like it may process the expression before it makes it to its new cell.

 

 

CADnoob

EESignature

0 Likes
Message 4 of 9

Anonymous
Not applicable

I appreciate your response. I do not know if I will know how to use what you tell me. When you say the field expression you mean to insert "% <\ AcExpr (C2)>%" as a diesel expression ?. Maybe I'm telling you something that is not possible. My knowledge is not so broad or I do not quite understand what you want to tell me. I'll try and tell you something.
Thank you very much.

0 Likes
Message 5 of 9

john.vellek
Alumni
Alumni

Hi @Anonymous,

 

Can you explain how you intend to use the linked date? I can enter a date as text and it formats correctly. I can also use a field to enter a date. It is only when this seems to break down.

 

I am thinking you could place the date outside the table and have fields link to that object.

 

Please add some detail and possibly a sample drawing for me to look at.

 

 

Please select the Accept as Solution button if my post solves your issue or answers your question.


John Vellek


Join the Autodesk Customer Council - Interact with developers, provide feedback on current and future software releases, and beta test the latest software!

Autodesk Knowledge Network | Autodesk Account | Product Feedback
0 Likes
Message 6 of 9

Anonymous
Not applicable

Hello, I create two tables (Table 1 and Table 2). Then in a table1 cell (for example) I write a date with data format (date). So all right (I think) And then in table2 I select a cell and the table order appears and I select format data --- date and then insert formula ---- cell and I select the cell where I have the date (= A2) for example . What autocad inserts is a decimal number. Autocad must recognize the date as a split and then do the operation. I want to do this because I do drawings with many layouts and in each layout there is a drawing with a box and its revisions and there is also a general layout with its box in which a list of all the drawings with their different revisions appears. So in this general plan is repeated all the revisions of each layout of each layout. And for me not to forget to update this general plan I wanted to link each revision table of each layout with this general revision table. Maybe there's another way to make it easier but that's what I thought.

 

Thanks for taking the time to solve my problem.

0 Likes
Message 7 of 9

TheCADnoob
Mentor
Mentor

This is looking more and more like a bug in the program. 

 

I would assume that linking a table cell would not evaluate the contents of that cell. I'm also having problems with it linking to a cell that contains text. This is likely because its trying to mathematically evaluate a text string. I would report this as a bug. 

 

 

As a work around you can explode that tables and just use the fields as you would normally do and point them to tother fields

 

you could also put your date data into the drawing comments section and just point the table filed to that data

 

or you could put a text object in the drawing with the date and have the talbles field point to the object property for that text object. 

CADnoob

EESignature

0 Likes
Message 8 of 9

Anonymous
Not applicable

Thanks for your advice. I will try to do it as you say.

0 Likes
Message 9 of 9

john.vellek
Alumni
Alumni

HI @Anonymous,

 

As I and @TheCADnoob suggested, did putting the original date outside of the table and linking to it work for your process?

 

Please add a post with how you decide to proceed and your results so other Community members may benefit.

 

Please hit the Accept as Solution button if a post or posts solves your issue or answers your question.

 


John Vellek


Join the Autodesk Customer Council - Interact with developers, provide feedback on current and future software releases, and beta test the latest software!

Autodesk Knowledge Network | Autodesk Account | Product Feedback
0 Likes