lunes, 23 de abril de 2012 20:01
Hi, when I try to create a business rule on a date field I get the following error message:
"Date postfix argument expected."
1. I have an entity with a DateTime leaf member attribute. This attribute also has change tracking enabled.
2. I then try to create a business rule with the IF "has changed condition".
3. When I try to save this rule, I get the error stated above.
I'm not sure what the error means, any ideas? The error does not occur with non-DateTime attributes. Thanks!
- Editado Henry Ong lunes, 23 de abril de 2012 20:02
Todas las respuestas
miércoles, 13 de junio de 2012 14:21
The default date formate is mm/dd/yyyy hh:mm:ss AM/PM.
Eg., 12/31/1994 12:00:00 AM.
If the value is in above mentioned format, you will not get "Date postfix argument expected" error.
The "Date postfix argument expected" error occurs due to unavailability of time stamp at end of date.
Hope this will help you !
- Propuesto como respuesta kailash11k miércoles, 13 de junio de 2012 14:21
miércoles, 08 de agosto de 2012 18:39This is a problem for me as well. when a date field changes, I want to change another attribute value. can't even get the business rule to save.
miércoles, 12 de septiembre de 2012 22:41Anyone found a solution to this issue? The initial version of MDS in SQL Server 2008 R2 had an issue with Date Attributes and the "equals" Action (i.e. the target attribute was never set). Now we have an issue with Date Attributes and the "has changed" Condition. Makes me wonder if anyone is testing this stuff.
viernes, 05 de abril de 2013 13:20
Still no workaround for this issue ? The one proposed above does not work as MDS does not accept hh:mm:ss date definition, it only handles days months and years... I tried on both Admin UI and Excel Add-in and
1) Admin drop down does not includes hours
2) One can put it manually in Excel in Attribute Property but once you close the popup it gets erased...
So for now change tracking is not supported on dates ?
lunes, 08 de abril de 2013 7:53
Some more information from Henry would be helpful. I have created a rule on 2012 and got no error (but I have not enabled change tracking for that particular entity).
1) What version of MDS are you using MDS 2008 R2 or MDS 2012? Am I correct to assume 2008 R2?
2) What change tracking group have you used for the "has changed" condition?
3) What action has been selected?
martes, 09 de abril de 2013 7:55
This issue has been fixed after install Service Pack 1 for SQL Server 2012. For more information, please see the KB article: