I am trying to read a CSV file into VB.NET datagridview which is fine i did already but one of datagridview coloumn is date and time i want to convert it to human readable format and want to read the correct format in date and time column in all rows like if i have 100 records it should correct or convert all 100 records date and time into correct format in that column and the column number is 4.
Any sample code example will be much appriciated.
I did conversion in excel by using the below formula it works fine and shows correct format,
=(B2/86400)+25569) which brings me correct format.
Please help on this.
Many Thanks in advance.