Hi!
Somebody how to convert an attribute of date type, in a value. This value will be the number of day of the year of the date.
Thanks a lot!
Xavier C.A.
Xavier Coll • Architect, Project Manager I+D, BIM Manager, BIM Auditor
EiPM • http://www.eipm.es/en/
if you want to use this calculation at a point where you can use EXCEL (as in Valable Textbilder) you can use something like this:
=TAGE(E10;DATUM(JAHR(E10);1;1))+1
E10 is in my case the Cell with date ...
Allplan Webentwicklung
Private messages must be private. No support request via Private message.
Thanks to answer Velletti!
I'm agree with you, in excel is possible to change a date to a value. But, inside Allplan is possible to create a fórmula for use it in "Label style" and Legends?
Best regards,
Xavier C.A.
Xavier Coll • Architect, Project Manager I+D, BIM Manager, BIM Auditor
EiPM • http://www.eipm.es/en/
in many places you can use Excel forms inside of allplan (i am not shure hwat function is "label Style" in german )
may be this link helps
Allplan Webentwicklung
Private messages must be private. No support request via Private message.
Hi Velletti,
Thanks for the link, it's very interesting :-) Well, the "Label Style" english command is "Beschriftungsbild" in deutsch (see image 03 attached).
Imagine a file with a group of columns with two atribute of date: date of start of construction, and a date of end of construction. And this dates are the same for all the columns. (see image 01 attached).
We would like to control the number of days of construction of the columns, in "real time" and inside Allplan.
How to do it? Well, we are now trying the command "Legend" to do it, because the Legend is in "real time", and inside Allplan.
If you see the image 02, you will see how we are thinking about it. There is a formula in the image to calculate the days from start date to end date, but this doesn't work....
The question is: how to write the formula to calculate the number of days?
Thanks!
Xavier C.A.
Xavier Coll • Architect, Project Manager I+D, BIM Manager, BIM Auditor
EiPM • http://www.eipm.es/en/
if fieldtype is a Number, the following could work:
=TAGE(01_DATE End;01_DATE Start)+1
or maybe without "=" at the beginning
TAGE(01_DATE End;01_DATE Start)+1
but i will also ask internaly by the guy who had programmed this modul ...
Greetings
Jörg
(Velletti)
Allplan Webentwicklung
Private messages must be private. No support request via Private message.
TAGE = DAYS ... and with excel you can also calulate wiht other excel special things like workdays() ...
Allplan Webentwicklung
Private messages must be private. No support request via Private message.
Thanks Jörg to answer fastly!
We are trying to do all you explained in the last posts.
To do it fastly, we are using the formula from the tool "label styles" (Beschriftungsbild)
We have created three formulas in three different languages??:
TAGE(02_DATE End;01_DATE Start)+1
DAYS(02_DATE End;01_DATE Start)+1
DIAS(02_DATE End;01_DATE Start)+1
(the last formula is in spanish, because our Windows and Office is in spanish)
But all those formulas didn't work.....
Xavier Coll • Architect, Project Manager I+D, BIM Manager, BIM Auditor
EiPM • http://www.eipm.es/en/
I send a mail to the developer, but as i got no answer, it looks as he is in holiday ..
did you try it with the "=" sign in front? and, you are right, it will be good to use the spanisch translations of the excel commands ..
Allplan Webentwicklung
Private messages must be private. No support request via Private message.
Hi Jörg!
First of all, thanks for answer and thanks for asking to the programmer too :-)
It's important to comment two things:
- The language of Microsoft Office: If it's in spanish, the name of excel functions will be in spanish.
- The version of Microsoft Office: some functions don't exist in old office versions. For example: the TAGE function (days / dias) exist in Office 2013 and Office 360, but it doesn't exist in Office 2010.
In our office, we still work with microsoft Office 2010, spanish version.
Instead of using "DIAS" function (TAGE / DAYS), we tried with an other excel function, "DIAS.LAB" function (NETTOARBEITSTAGE / NETWORKDAYS) and now it works!!! (see image 01)
Only we found a little bug: The attribute can not be of "Date" type (see image 02)
Thanks Jörg!
Xavier C.A.
Xavier Coll • Architect, Project Manager I+D, BIM Manager, BIM Auditor
EiPM • http://www.eipm.es/en/
