Remove Time in Transaction_Date Column in excel

Help Activities
, ,
#1

Hi ,
i have an excel file in that Transaction_Date Column want remove time and write
FIlterData.xlsx (8.6 KB)
date in Same sheet.

Exp— input ouput

     ->3/20/2022  12:00:00 AM         3/20/2022

image
image1243×460 29.6 KB

#2

Hi @Anand_Designer

Please find the attached code done using linq

Sequence1.xaml (5.8 KB)

Thanks

for read range and write range pass your same excel path

1 Like
#3

i hope that works fr you @Anand_Designer

#4

its working fine. in.xlsx format working fine.
but my client file is in .csv format.

(.csv Format File)

in that its writing same data(Wrong) in that column(D) . but in other column(H) its writing correctly.
why its difference in .csv Format ? i am getting issue with this.

Example in pic below

image
image1224×670 36.1 KB

#5

Could you share me the input CSV file @Anand_Designer

#6

use this code in Invoke VBA Activity

Sub FormatDate()
Sheet1.Range(“D2”, “D50000”).NumberFormat = “yyyy-mm-dd”
End Sub
and set entry point as FormatDate instead of Main.

Mark this as solution, if you are able to achieve what you have expected.

1 Like
#7

While I am trying upload .CSV file into forum it’s not allowing to upload that format.can you use same file save as in .csv extension.

#8

@Anand_Designer Try below steps

  • Read the data from an excel (Assume excel1)
  • Remove the time from the column
  • Write the updated data to the same excel sheet (excel1)
  • Now again read data from excel (excel1) by enabling Preserve Format in Read Range activity and read to a data table

Capture

  • Now, write to CSV it should write the data with same format