Get latest date for a transaction date from another list

Hi,

Use a query List action to query List 1
Filter by TransID
Sort by Date Ascending
Output into a Collection Variable.

Use a Collection Operation action.
Select your collection variable.
Select the POP option (pops the last item out of the collection which will be the latest date based on the sort in the previous action)
Store output in a Date variable.

Update List 2 with Date Variable.

Hi SimonMuntz,

I am very new to Nintex workflows or forms.

Is it possible to give some screenshots? I don't understand what to give in Query list filter when it asks for 'TransID' is equal to field? 

Also, how do I update the list item with the date variabe created?

 

Sorry for multiple questions, but I can really use your help :)

For testing you could use TransID is equal to 1005.

Going forward you could read the TransID from the TransID column on List 2.

 

To update the item use an Update Item action.

Thanks Simon. I have created the workflow in wrong list earlier. 

It is working now. However, when i create the item in master list first time, the date should be updated to created date.

 

Is there any formulae or workflow logic to achieve this?

How are you creating the item in the master list?
The easiest way would be to set the defaut value to "Todays Date" in the SharePoint Date column setting. When an item is created it will automatically be set with todays date.