I have a date field in a document set content type. My working environment is in SharePoint online and I am implementing this workflow specifically in Sharepoint Designer. I am keeping 2 other hidden date fields to keep track of the current date and previous date.
The only way I have managed to achieve this, is by creating a workflow which runs on item changed (which means when a column is edited from the document set). Then at the start of the workflow, I check whether Date is different to HiddenDate1 and if yes I do the logic. i.e. set Date to HiddenDate1 and HiddenDate1 to HiddenDate2. This way the HiddenDate2 is always the previous and Date is always the current.
I would like to initiate the workflow just when the Date field specifically is changed, contrary to having to still access the workflow to check the condition in the first step, when any column in the document set is modified. By doing this, I will get rid of unnecessary workflows being run in the background (the system is already overflowed with workflows, and if I had to add a workflow for each document set type, I would need to add at least 10 more) and this will also prevent the document sets from changing versions unnecessarily.
Thanks for your help in advance.