How to formate date

Help
1

Hi ,

I have effective date in this format (22-07-2018)in excel .I want to convert 22-july-2018.the whole colomn has to change above format.

How can i do this.Can anyone help me here?

Thanks

2

Hello @cheersrpa

See this example below

DateTime.Today.ToString(“dd/MMMM/yyyy”)

3

hello,

not todays date.I have dates in excel with different dates.

1 Like
4

You can try this

Yourdate.ToString(“dd-MMMM-yyyy”)

1 Like
5

@cheersrpa

Yes you can do.

ListA= (From p In dta.Select
          Select Convert.ToString(DateTime.ParseExact(p("EffectiveDate").ToString,"dd-MM-yyyy",System.Globalization.CultureInfo.InvarientCulture).Date.ToString("dd-MMMM-yyyy"))).ToList

Next Run for Each and Update the Column

Regards,
Mahesh

6

Hi @mahesh1

FYI… i am attaching sample file in that the data is in dd-MM-yyyy format.I want the date to be in
dd-MMMM-yyyy format.So the output will be updated sheet with the formated date.

No need to change the other coloumns

Thankstest.xlsx (9.3 KB)

7

I tried with the above syntax…its printing as dd/MMMM/yyyy :frowning:

8

Hello @cheersrpa

I tried another way and I got it.

see attachment test.xlsx (10.3 KB)
testDateTime.xaml (9.9 KB)

3 Likes
9

hey @dkollyns

Perfect !.

Thanks you so much for the help.

1 Like