From number to month

Help Studio
1

Hello
I have to do the following

if the column in excel says
8/20/2022
8/30/2020

must stay
August
January

2

Hi @GDMM ,

Could you maybe explain what are you trying to perform ?

If trying to convert the dates to Month, the First Date does convert to August, However the Second date also converts to August.

Is that a typo from your end or is there a different Logic Involved.

For a Quick Check, try the below :

CDate("8/20/2022").ToString("MMMM")
3

Hi Check this

image
image1428×51 3.05 KB

DateTime.ParseExact("8/20/2022","M/dd/yyyy",system.Globalization.CultureInfo.InvariantCulture).ToString("MMM/dd/yyyy")

DateTime.ParseExact("8/20/2022","M/dd/yyyy",system.Globalization.CultureInfo.InvariantCulture).ToString("MMMM/dd/yyyy")

image
image1445×59 3.22 KB

Thanks,

4

HI @GDMM

Checkout this expression

DateTime.ParseExact("8/20/2022",{"M/d/yyyy","dd/MM/yyyy","d/M/yyyy","MM/dd/yyyy","MM/dd/yyyy hh:mm:ss"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("MMMM")

image

Regards
Sudharsan

5

@GDMM

You can directly change the format ofthe cella in exce manually or using bot format cell or range activity and set the format to MMMM then it would directly display the month

Cheers

7

correction

if the column in excel says
8/20/2022
8/30/2020

must stay
August
August

8

must be the whole column

9

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