Set column value in a document property

[Sander Koster]

Hi,

I think I have a very easy question, but I can't find the answer.I would like to set the Max([Date]) value from a column toa document property. Does somebody knows how I can fix this with a script or more easy

The [Date] is a column in my SQL dataset.

Thanks you!

Sander

[Kirsten Smith (she/her)]

You will need develop a script or data function to update the value in your Document Property. This KB article outlines how to update a Document Property with the current date, you should be able to modify this slightly to get the desired Max([Date]).

 

https://support.tibco.com/s/article/Tibco-KnowledgeArticle-Article-44164