Hi buddy,
I am trying to search the system date in a table, and get the corresponding statement date cell. The end result is in dd/mm/yyyy 00:00:00, without error. However, I want to have the end result in “dd/mm/yyyy”. When I try row(“FromStatementDate”).ToString(“dd/mm/yyyy”) in the last sequence, it return error. Please help.
Input.xlsx (12.1 KB)
VLookup.xaml (14.3 KB)
Kind Regards,
Steven