Formatting date column

Help Studio
1

Hi Team,
I need help. I have the date as in the below format.
image

I would like to change the format to the below one
image

Please let me know how to do this,

thanks
Sri

2

looks like the same scenario

e.g. reformatting

Or Prepending Apostroph trick

1 Like
3

adding one more post which you can refer.

I think Format cell activity can be used easily in this case.

1 Like
4

Hi @ppr ,

Thank you so much . But i am not replicate.

Can you please share the .xaml? Below is the attached excel file.
ask_uipath_format.xlsx (8.8 KB)

5

Hi @Rahul_Unnikrishnan

Thank you. I am trying something like this . But not working.

image
image1056×608 19.3 KB

6

Hi @ppr @Rahul_Unnikrishnan ,

Please let me know if anything i am missing,

Thanks,

7

@srinivas_pradeep
Try :
cdate(Input.ToString).ToString(“yyyy/MM/dd”)

8

Hi @Vaibhav_Rajpoot_17 ,

Thank you for the suggestion. Can you please let me know what will be the input here?
i have to change the “Date” column in the attached excel file.

Thanks

9

image
image1115×563 18.5 KB

10

@srinivas_pradeep
have a look here, especially at the provided description on how the datatable can be inspected within the immediate panel during debugging

:ambulance: :sos: [FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

if really an OADate number is to handle, then we will convert it into a number as the method will work with numbers and not with strings

11

@srinivas_pradeep

find the workflow:
Main.xaml (8.7 KB)

Let me know, if you have any other query.

1 Like
12

Thank you very much @Vaibhav_Rajpoot_17 .
It works perfectly.

have a nice day,

13

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