Any method for keeping the date as it is?

Help Studio
, ,
1

hi all,
Is there a way for me to keep this string without UiPath automatically converts it into “2023-July-10” when the excel data is as shown?

ss1

2

Hi @attkren1

You can use the format cell activity. It will format the datatype of the specified cells.
In format cell activity you can give the range after that you can select the general datatype then it will change to general.

Hope it helps!!

3

How can I do it when my workflow is already using another excel activity?
Sorry, Im confused

ss2

4

Hi @attkren1

Once try with check on Preserve Format option in Read Range Workbook activity

I hope it works!!

5

@attkren1

Try this

image
image616×710 22.1 KB

6

HI,

FYI, another approach:

Can you try to add “'” at the beginning of your string as the following?

"'" + yourString

Regards,

7

It does not work too.

ss3
o

8

to my date string? or you mean to edit the data in excel?

9

Yes. Can you try it in UiPath?

Regards,

10

still cannot.
It prints out '2023-Jul-10

11

Hi,

Sorry but I had misunderstanding you want to input the data into excel.
How about the following expression?

CDate(yourString).ToString("M/d/yy")

Regards,

12

Hi @attkren1 ,

image
image912×571 18.5 KB

Regards,

13

hmm i want it in only numerical format. e.g. 7/28/23

14

it is still giving me 2023-Jul-10. I want it in only numerical format. e.g. 7/28/23

15

Hi,

image
image734×553 12.6 KB

Regards,
LNV

16

Hi,

The above expression returns M/d/yy style string as the following.

image

Doesn’t this work for you?

Regards,

17

ok realized that capital and small letters matter. thanks

18

Hi,
Custom what you want

image
image719×458 12 KB

Regards,
LNV

19

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