I’m working on a BPM on part duplication. We have a field on the part table for “Date Part Created” so they want it set to the date the part is duplicated. I’ve set BPM data fields and have a test message display the date. So I know the expressions are working to set dates but I can’t get it to update the field.
I’ve tried setting it to All Rows, Updated, Added, etc
For the expression I’ve tried:
I remember a while back dealing with something similar and we ended up using a pre-processing directive for the condition and to enable a post directive. The post did the actual update.
The way I did this was to pass targetPartNum in the pre-processing to the BPM context data and then use it in the post directive to update the correct part. Probably guessing there is an easier way but fought with this one for a while.
How to you set a DateTime UD field back to unset/cleared/blank?
In the DB they are nullable SQL datetimes.
But when trying to set em to NULL to DBNULL or whatever it doesn’t seem to work.
Setting the UD datetime field to another yet unset UD DateTime Field doesn’t work either.
I get “The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value” this in the serverlog, that is in E10.2.500.8