Date Format issue Changes while filter

Hi

I use to download the excel from the jasper report
In Jasper, the date format is like
image
When I downloaded the format of the date is like this
image

Again I use to filter the data using Activity, it changes again like this

image

I want the date this formate to be changed in regular date format,
How can i do??

2 Likes

Fine
Once after getting the last excel type of file use a READ RANGE ACTIVITY and get the output with a variable of type datatable named dt
—now use a FOR EACH ROW loop and pass the variable dt as input
—inside the loop use a assign activity like this
row(“yourcolumnname”) = DateTime.FromOADate(Convert.ToDouble(row(“yourcolumnname”).ToString)).ToString

Cheers @sudhasagar

Thank you for supporting…

1 Like

Cheers @sudhasagar

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.