How to Read Date Column from excel Date Data Type

syed said:

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?

Click to expand...

Amarender said:

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

Click to expand...

syed said:

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.

Click to expand...

Amarender said:

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.

Click to expand...