How to convert date in column to date format(dd/MM/yyyy)

[POOJA_MARUTI_BALIGIDE (Amada)]

Hello,

How to convert date in column to date format (“dd/MM/yyyy”).
test.xlsx.xlsx (8.4 KB)

Note: I have to convert all for files in folder.

[Srini84 (Srinivas Kadamati)]

Hi @POOJA_MARUTI_BALIGIDE

Check below post for your reference

Change date format in column

Hey everyone I have a column in a datatable where the format of date is d.MM.yyyy , I want to change it all values in this column to MM/d/yyyy and I cannot use for each activity because there are to many rows to take this action for each row. I might change the “.” with “/” using .Replace but I have no idea how to change the position of day and month. I appreciate every bit of help, thank you

Hope this may help you

Thanks,
Srini

[POOJA_MARUTI_BALIGIDE (Amada)]

@Srini84 ,

I have referred the same solution and used vb .net code. its not changing the format in file

[Srini84 (Srinivas Kadamati)]

Hi @POOJA_MARUTI_BALIGIDE

Understood, then you need to look at the VBA code for that

Check below link for your reference

https://www.wallstreetmojo.com/vba-format-date/

Once you ready the script save as .txt use Invoke VBA code activity to run and check

Hope this may help you

Thanks,
Srini

[Anil_G (Anil Gorthi)]

@POOJA_MARUTI_BALIGIDE

You can use for each file in folder to get each excel file

Inside loop use format cells activity and format the excel cells you need to the required format

Select custom and tehn give dd/MM/yyyy

Cheers

[POOJA_MARUTI_BALIGIDE (Amada)]

@Srini84 ,

Please find the below xaml file,its not giving any error , and format is same as old.
Sequence.xaml (10.4 KB)

[POOJA_MARUTI_BALIGIDE (Amada)]

@Anil_G ,

Thank you the reply. Please find the below file.I am using invoke code activity to change the date format but its not changing.

Sequence.xaml (10.4 KB)

[Anil_G (Anil Gorthi)]

@POOJA_MARUTI_BALIGIDE

Instead of invoke please use format cells activity which is under modern excel activities

Cheers

[Shiva_Nikhil]

@Anil_G

thank you @Anil_G its working fine with modern activities

i have learnt a new one
Thank You

[ppr (Peter Preuss)]

@POOJA_MARUTI_BALIGIDE

but its not changing.

it is changing the dt

done with

Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

One of the very important topic of UiPath in Debugging is understanding the different debugging panels and when to use which panel during debugging. In this video, we will understand all the 6 debugging panels of UiPath in the easiest way possible. Video Link: Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - YouTube

But when the updated data is needed to be reflected at the excel you would have to write it back to excel

[POOJA_MARUTI_BALIGIDE (Amada)]

@Anil_G @Shiva_Nikhil ,

For me its not working, I can see the file is getting modified to latest time.

[Anil_G (Anil Gorthi)]

@POOJA_MARUTI_BALIGIDE

May I know what is modified

the dates are modified? Or the format you wanted is not coming?

Cheers

[POOJA_MARUTI_BALIGIDE (Amada)]

@Anil_G ,
I want the date format in (“dd/MM/yyyy”).

When I run the process, its file getting modified(Last Modified Time

) .but the date format within the file is not changing.

[Anil_G (Anil Gorthi)]

@POOJA_MARUTI_BALIGIDE

In the custom field of format cells did you provide proper details?

Cheers

[POOJA_MARUTI_BALIGIDE (Amada)]

@Anil_G ,

Yes ,I have given the details.

[Anil_G (Anil Gorthi)]

@POOJA_MARUTI_BALIGIDE

I just tried and it is working as expected. Can you send me the file which is not workign please… or as a test can you create one dummy file and test if that si gettign modified

Provided format is with - while entering but repalced in code with /

cheers

[POOJA_MARUTI_BALIGIDE (Amada)]

@Anil_G
PFA as example.& I want to perform is for multiple files where range is dynamic.

Payments (2).xlsx (8.5 KB)

[POOJA_MARUTI_BALIGIDE (Amada)]

@ppr ,

Thank you , This solution also works.