Write full Date Format in Excel column

Help Activities
, , , ,
1

Hi,

I have this Date Column as shown below:

image
image130Ă—715 2.41 KB

I want to change it to full sentence format as such:

image
image277Ă—719 4.3 KB

So these are the months and how it should be written:
image

Can anyone help please?

Thanks!
UIPath_Excel_Scratch (1).xlsx (153.5 KB)

2

Hi @Yudhisteer_Chintaram1 !
Here is a suggestion: Date_conversion.xaml (9.7 KB)
Beware, there is a strange date format at the end. I took care of it in the code through Try Catch but I wanted to let you know if it’s a forbidden/forgotten date format:
image

1 Like
3

Thanks Am learning new things.

1 Like
4

Wow. Thanks a lot @Hiba_B .
It worked great!

1 Like
5

But wait…we have a 0 in front of a single digit. Can we not have it?
image

Like in the screenshot I provided above.

I know you always help me for regex problems. Maybe you can do something here? :slight_smile: @prasath_S

6

@Yudhisteer_Chintaram1 - this doesn’t require regex…

If you dd MMM yyyy or dd MMM yyyy to d MMM yyyy or d MMM yy

7

It is: image

8

@Yudhisteer_Chintaram1 - d definitely won’t print 03 …only dd does …it may be the culture or the excel sheet…

9

Hi @Yudhisteer_Chintaram1 …I took your previous post and split & Convert(in one step) as shown below… Please check…

image
image1392Ă—530 40.8 KB

Invoke code…

dt.AsEnumerable().ToList().ForEach(Sub(row) row("Date")=datetime.ParseExact(system.text.RegularExpressions.Regex.Match(row("INV Date / BL Date").ToString,"[\d/]+$").value.Trim,"d/M/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString(“d MMM yyyy”))

Hope this helps…

2 Likes
10

Hi @Yudhisteer_Chintaram1 !
As @prasath17 is saying, it’s in the writing process that you need to change, so it’s here:

image
image733Ă—511 14.2 KB

2 Likes
11

Perfect! :slight_smile:

12

Thanks man!! :slight_smile:

1 Like
13

Hi @Hiba_B ,

Just a quick question. What do we have to change to write the full Month?
That is, for now for “April” it is written “Apr”
But I want it to write “April” in full sentence?
Thanks!

14

Oh I thought that you wanted only 3 characters; in the last assign string_date, replace MMM by MMMMMMMMM (because september has 9 characters and is the longest one) and let us know, i did not try it so if it makes something strange then we will change its type

15

@Yudhisteer_Chintaram1 - Just MMMM should be fine… Please refer all the datatime formats here…

1 Like
16

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