Skip to Content
Former Member
Jan 13, 2009 at 10:17 PM

automatically populate current date in udf on BOM


Hello Everyone,

I have created a user defined field on the line item of the BOM that I would like to be populated with the current date when a child item is changed, or there is a new child item added. We're going to use this field as the "valid from" date. I'm planning to use a search function that identifies a query which tells the system to populate this "valid from" field with the current date when a child item is added, or an existing child item is changed. I do not know what table/field combination to use to get the current date. Would anyone be able to help me with the query that would be needed to populate this field. I will award points. Thanks in advance for the help.