Im trying to add the last revision letter, revision date & issue dates to a worksheet schedule similar to the info you've been discussing, Ive found the following info on a Dutch VW forum which may be of use to others -
DATABASE = ((R IN ['Drawing Border - Universal']))
and then the cells:
Revision information:
= ('Revision Date'. "Date-1)
= ('Revision Date'. 'Zone 1')
= ('Revision Date'. "Approved-1)
= ('Revision Date'. 'Description-1)
comments:
= ('Issue Date'. 'Number-one')
= ('Issue Date'. "Date-1)
= ('Issue Date'. "Note-1)
= ('Issue Date'. "Approved-1)
Note that those " 1 "Here always represents the line of the revision or comment.
Can anyone help me work out what the formula needs to be to get the LAST revision & revision date to work in a drawing issue worksheet? - as this only gives you the first rev or second if you change it to "2" etc..
