Get current date

Learning Hub
1

Hi I’m new in uipath

I want to get today date format as “11June2020” without space. How can I do that?
I find this method “now.ToLongDateString()” and the result is ----> “Thursday, 11 June 2020”

But i would this format “11June2020”
How can I do that?

Thanks in advance

2

Now.ToString("ddMMMMyyyy")

1 Like
3

thanks @Anthony_Humphries but with your method the result is this “11/06/2020”

4

Something else in your workflow is causing that. Here is what my post does:

image

1 Like
5

thank you yes with the message box the output is like your image but I forgot to explain that the date must be written in an excel cell, do you know how to do that?

thanks in advance

6

It depends on how you’re going about writing to excel. If you’re writing a datatable to Excel, you’ll need to set a String type column in the datatable to what I’ve given above. If you’re using the Excel Application Scope, you can use the Write Cell activity to pick a specific cell in your workbook to which to write the string.

7

yes sorry again, because if I use your method when I then go to write on the cell excell converts so “11/06/2020”. Like my images

write cell activity:
Screenshot_3
cell Excel

Screenshot_4

8

Try changing it to String.Concat("'", Now.toString("ddMMMMyyyy")). The ' should force Excel to read what you’ve entered as a string.

9

now it works, thank you so much for your help

10

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