Forum Allplan

How to convert an attribute of date in number of day [Risolto]

Tags:

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/

11 - 14 (14)

maybe the Attribute can still be a DATE Value, but you convert it also in your Formular from Date to Text.
so possible entrys in Allplan are always valid date/Time entries (not something like 30.feb.2014)

But Cool that i could help with this. (without a running allplan version)

jörg

Allplan Webentwicklung

Private messages must be private. No support request via Private message.

Hi Jörg,

We try to convert Dates in text in a formula, but It's impossible to do it (or maybe we dont' found how to do it...)

We try other Excel functions inside Allplan formulas, and some of the functions don't work.

Are there any list of Excel functions compatibles to use with Allplan formulas?

Thanks!
Xavier C.A.

Xavier Coll • Architect, Project Manager I+D, BIM Manager, BIM Auditor
EiPM • http://www.eipm.es/en/

you can do it on a other way, if you want to use VBScript.
with use of VBScript you can define your own functions.

I have to search this toppic.... it have been diskussed earlier in forum... an i used it some time ago..

Namenlos gezeichnet in vollem Bewusstsein - ignorant, in eigen Augen vermutlich höflich, dennoch unhöflichst, unfreundlichst wer einen/viele vermutete - sich von alters erschließende Namen nennt.
08.01.2024 - Gegen Bauernsperren! -> Boykott der direktverkaufenden Bauern - kauft nicht mehr direkt bei Bauern!

Thanks to the answer, Markus!

Well, We have some other "little" question:

- is possible to write a VBAScript in the formula? How to do it? Some simple example? ;-D

- We would like to create a special "Label style" (Beschriftungsbild): This "Label Style" will change his text colour in function of one determinate value of an atribute of an architecture element. Exist any function to do it?

- Inisde Allplan, are there any attribute to read the Layer of an element?

Thanks!!
Xavier C.A.

Xavier Coll • Architect, Project Manager I+D, BIM Manager, BIM Auditor
EiPM • http://www.eipm.es/en/

11 - 14 (14)

https://connect.allplan.com/ utilizza cookies  -  Maggiori informazioni

Accetta