Hi,
I am reading data from excel where it has around 20 column. One of the column is a date format( eg. 28-02-2019)... But after reading it the value is coming as Date Time. How Can I get only date value?
Hi Syed
You mean Row has Data as Date (Eg. 28-02-2019) but after reading that into BP your are getting (Eg. 28-02-2019 XX:XX:XX) right.
Simple way to get that is, Using Calc Stage "Functions>Text>Left([Date Time], 10)".
Hope you understand and is Helpful
Thanks and Regards
Amar
Hi,
Thanks for your reply... There are 6000 rows. So, I can't keeping changing for all the rows. So, I am just changing the format of that particular column using VB script before processing it.
Hi Syed
I wonder how you process 6000 rows in a process at a time. No need to process each row differently before, you will process that data when you get it to work on it.