month Format

[Jintal Patel]

hi i want to get current month in three letter format .Like my string value return 'Oct'

Jintal Patel

[r a j u u]

u can use..select cast(Datename(month,getdate(),varchar(3)) from tablename..it will work.

Rajendran

[soni uma]

Try this it help u select cast(Datename(month,getdate()) as varchar(3))

[John ph]

str = Format(Date.Today, ("MMM"))

Regards
 - J O H N -

---

[Phil Osborne]

This will get the current month for you. The important bit is the ToString("MMM") which formats the month. Create a label control and name it Label1 then add this code: Label1.Text = DateTime.Today.ToString("MMM"); Enjoy.

[Pete OHanlon]

This sounds like the answer of an Eagles/Clapton fan. High 5 for you sir.;)

Deja View - the feeling that you've seen this post before.

[Jintal Patel]

hi this gives me the some other language text...

Jintal Patel

[Ahmad Adnan]

System.DateTime.Now.ToString("MMM"); i think it will work. and u can apply it to any other DateTime object regards