how to get latest date data

[Rajeev18]

Hello,

Considering today's date - 7th March 2020, then i need that yesterday's date (i.e. 7th march 2020  minus 1 = 6th march 2020) data should come in my output file 

Input file: - 

Product ID	Product Name	1st level Approval status	1st level Date	2nd level Approval status	2nd level Date	2nd level Approval status	3rd level Date
12345	M	In Transmit	12/13/19	Submitted	12/13/19	Rejected	03/06/20
23456	N	In Issue	10/19/19	Submitted	10/19/19	Submitted	03/06/20
98766	Z	Accepted	12/13/19	In Issue	03/06/20	In Issue	12/13/19
45678	A	Accepted	11/25/19	Accepted	11/25/19	Accepted	11/25/19
32156	B	Accepted	12/13/19	Rejected	12/13/19	Accepted	03/06/20
23457	C	Rejected	03/06/20	May get Rejected	03/06/20	May get Rejected	12/12/19
45678	W	Submitted	12/11/19	In Transmit	12/11/19	Rejected	12/11/19
12980	X	Accepted	12/11/19	Accepted	12/11/19	Accepted	12/11/19
45987	Y	Rejected	12/01/19	Submitted	12/01/19	Submitted	03/06/20
345678	Z	May get Rejected	12/11/19	Accepted	12/11/19	Accepted	03/06/20
234568	Q	In Issue	03/06/20	Submitted	10/27/19	Submitted	10/27/19
98765	s	Accepted	12/13/19	Rejected	12/13/19	In Transmit	12/13/19

output file data required:

Product ID	Product Name	1st level Approval status	1st level Date	2nd level Approval status	2nd level Date	2nd level Approval status	3rd level Date
12345	M	In Transmit	12/13/19	Submitted	12/13/19	Rejected	03/06/20
23456	N	In Issue	10/19/19	Submitted	10/19/19	Submitted	03/06/20
98766	Z	Accepted	12/13/19	In Issue	03/06/20	In Issue	12/13/19
32156	B	Accepted	12/13/19	Rejected	12/13/19	Accepted	03/06/20
23457	C	Rejected	03/06/20	May get Rejected	03/06/20	May get Rejected	12/12/19
45987	Y	Rejected	12/01/19	Submitted	12/01/19	Submitted	03/06/20
345678	Z	May get Rejected	12/11/19	Accepted	12/11/19	Accepted	03/06/20
234568	Q	In Issue	03/06/20	Submitted	10/27/19	Submitted	10/27/19

[JosephSerpis · Accepted solution]

Hi @Rajeev18 I mocked up a workflow that produces your desired output. Let me know what you think?

[ramesh_neel · Accepted solution]

@Rajeev18  - Here is my solution by just using date conversions (to convert date fields which are in string format to date formats ) and filters.