Date_Format_Issue

@Gokul_Murali Do you have any idea to run macros.
Before reading file Run macro for specific column and make same format for all cells.
Then read the excel file.

Do you have any workflow regarding this

Hi @Gokul_Murali
Try this
Convert.ToDateTime(CurrentRow(“Service Date”).ToString).Date.ToString(“dd/MM/yyyy”)

I hope it helps!!

@Gokul_Murali let me check please share excel file.

@lrtetala

This expression will not take if the cell format is text,

this expression only work for the cell with date format.

@Gokul_Murali Can you share that Excel?

@aanandsanraj

DATE FORMAT EXCEL.zip (6.3 KB)

@Gokul_Murali

Check this source
DATE FORMAT EXCEL.zip (9.7 KB)

I just used a normal process flow i will move this to the REFRAMEWORK flow, and let you know if there is any error.

@aanandsanraj
Iam getting an error like this when i try to move this to reframework

@Gokul_Murali Did you create a variable datevalue as DateTime?

@aanandsanraj

Brother still the same issue
same issue happening when i moved to reframework workflow.

@Gokul001

can you help me out on this

1 Like

@Gokul_Murali are you not able to solve your problem?

did u select preserve format ? while reading the data from excel

nope brother

@Gokul_Murali

First try using format cells and set the format as text and then read the range and check if it solves

cheers

@Gokul_Murali will design solution for you.
But tomorrow i will be able to send you.

@Anil_G
@lrtetala
@raja.arslankhan
@aanandsanraj
@Sahil_Tomar

Guys i used an activity called Date formatter under the package “NovigoSolution.DataTableDateFormatter.Activity”.

Now it is working fine, irrespective of excel row format.

3 Likes

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