Date format


#1

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


#2

Hi @steven_chan,

Use this code
Convert.ToDateTime(row("FromStatementDate").ToString).ToString("dd/MM/yyyy")

Regards,
Arivu


#3

Thanks buddy. it works!


#4

Use Convert.ToDateTime and try . It will work