Hi there,
I have a table which has 3 columns.
Name : Tel : Record Entered Date
ABC : 123: 1 May 2020
DEF : 234 : 3 May 2020
GHI : 345 :20 May 2020
JKL : 456 : 15 Apr 2020
My desired Output (below) would be for column 1 to display the max date in record Entered date as the data would have been correct till that date.
Can someone help?
Update Till : Name : Tel : Record Entered Date
20 May 2020 : ABC : 123: 1 May 2020
20 May 2020 : DEF : 234 : 3 May 2020
20 May 2020 : GHI : 345 :20 May 2020
20 May 2020 : JKL : 456 : 15 Apr 2020