Date format in element

[ja1234]

Hi,

(JScript) I want to programatically add the created date to an element.

Code: [Select]

var currentDate = new Date();
element.Created = currentDate ;
triggers Typeconflict.

currentDate  has the value

Code: [Select]

Fri Nov 6 10:28:20 UTC+0100 2015
in which format should the date be such that I can insert it into the element?

[qwerty]

It's a Mickeysoft Variant object. I know how to create that in Perl and VB but not in JScript.

q.

[ja1234]

The VB solution would be good also. Thanks!

[qwerty]

Ah. Now you got me.

Code: [Select]

currentElement.created = #2011-12-13#
currentElement.Update()
runs well, but it does not alter the creation day. I remember something that prevents (default) / allows altering of the creation date of objects. But I can't seem to find that back again in EA's options jungle  

q.

[qwerty]

Well, although the documentation tells that Created is r/w it obviously isn't. The date-thingy was probably related with diagram (it's somewhere in the mist of memories). Anyhow, there's always another solution.

Code: [Select]

Repository.Execute("UPDATE t_object SET CreatedDate='01.01.2010 12:00:00' WHERE Object_ID = <theId>");where <theId> is that of the object. This will do.

q.

[KP]

The option you're thinking of is at Tools > Options > Diagram > Allow change of Created Date

[qwerty]

Yes, right. Any idea what about the CreateDate not changing despite the documentation?

q.

[Eve]

The documentation is technically correct.

Read/Write means that a value can be assigned to that attribute. (vs assigning an value being an error at the compiler/interpreter level) It doesn't say what will happen to that attribute when you do.

It's the reverse of every single collection being documented as Read only. You can't change the object that is placed in that collection. It doesn't mean that you can't modify the object itself.

[qwerty]

The documentation is technically correct.

You mean like saying: the traffic light might take red color without explicitly telling you can be killed when crossing at red lights. You have a funny sort of humor I guess everyone will understand r/w that writing will be saved on update.

To cite the help for Update()

Updates the current element object after modification or appending a new item.

Now one of both is wrong. Either Created is R/Don't Care or Update() does not save changes to Created.

Please correct that.

q.

P.S. The same applies to Modified. It also does not save the supplied value.

[ja1234]

Well, although the documentation tells that Created is r/w it obviously isn't.

q.

Thanks q! This language independent solution that you suggested works. I was also confused as to why the element does not get updated, but as fallback to the direct database query, this does the job... Final code:

Code: [Select]

var el as EA.Element;
Repository.Execute("UPDATE t_object SET CreatedDate='01.01.2010 12:00:00' WHERE Object_ID = " + el.ElementID);
Result:


Was a lucky Friday 13 after all.  

[wikitect]

See also http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1447607897/0 wrt some circumstances under which the ModifiedDate for an element isn't updated (and also for connectors that have no metadata to capture creation or changes).

[ja1234]

See also http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1447607897/0 wrt some circumstances under which the ModifiedDate for an element isn't updated (and also for connectors that have no metadata to capture creation or changes).

Thanks, this means I should remove the modified_date after all..