A bug in populating mdm.tblTransaction by MDS?

Question

Hi,  I discover a bug (I think) on the process that populates the mdm.tblTransaction table.  If you have a date attribute in your leaf member, change the value, and check the values in columns OldValueand NewValue, you would notice that the date format used to store the date as strings are different.

For example,  I have athe following values being stored (as strings) in a record in the table mdm.tblTransaction, after I changed the date attribute value from 27/02/2013 to 27/2/2014   :

Old Value: '2013-02-27 00:00:00.000'  

New Value:  '02/27/2014 00:00:00'

Is this a set up /configuration issue, or is this a bug?

Answer 1

Hi,  I discover a bug (I think) on the process that populates the mdm.tblTransaction table.  If you have a date attribute in your leaf member, change the value, and check the values in columns OldValueand NewValue, you would notice that the date format used to store the date as strings are different.

For example,  I have athe following values being stored (as strings) in a record in the table mdm.tblTransaction, after I changed the date attribute value from 27/02/2013 to 27/2/2014   :

Old Value: '2013-02-27 00:00:00.000'  

New Value:  '02/27/2014 00:00:00'

Is this a set up /configuration issue, or is this a bug?