Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Retrieving year and month in YYYYMM format using datetime.now

Tags:

c#

datetime

I need year and month of date in YYYYMM format. I am trying to use

string yrmm = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString(); 

But this returns '20114' instead of '201104'. Any easy way to fix this?

like image 262
Priyanka Avatar asked Apr 28 '11 08:04

Priyanka


People also ask

How can I get only the date from DateTime format?

ToString() − One more way to get the date from DateTime is using ToString() extension method. The advantage of using ToString() extension method is that we can specify the format of the date that we want to fetch. DateTime. Date − will also remove the time from the DateTime and provides us the Date only.


2 Answers

Date Formatting in C#

<%= String.Format("{specifier}", DateTime.Now) %>  Specifier ---> Description ---> Output d ---> Short Date ---> 08/04/2007 D ---> Long Date ---> 08 April 2007 t ---> Short Time ---> 21:08 T ---> Long Time ---> 21:08:59 f ---> Full date and time ---> 08 April 2007 21:08 F ---> Full date and time (long) ---> 08 April 2007 21:08:59 g ---> Default date and time ---> 08/04/2007 21:08 G ---> Default date and time (long) ---> 08/04/2007 21:08:59 M ---> Day / Month ---> 08 April r ---> RFC1123 date ---> Sun, 08 Apr 2007 21:08:59 GMT s ---> Sortable date/time ---> 2007-04-08T21:08:59 u ---> Universal time, local timezone ---> 2007-04-08 21:08:59Z Y ---> Month / Year ---> April 2007 dd ---> Day ---> 08 ddd ---> Short Day Name ---> Sun dddd ---> Full Day Name ---> Sunday hh ---> 2 digit hour ---> 09 HH ---> 2 digit hour (24 hour) ---> 21 mm ---> 2 digit minute ---> 08 MM ---> Month ---> 04 MMM ---> Short Month name ---> Apr MMMM ---> Month name ---> April ss ---> seconds ---> 59 tt ---> AM/PM ---> PM yy ---> 2 digit year ---> 07 yyyy ---> 4 digit year ---> 2007 : ---> seperator, e.g. {0:hh:mm:ss} ---> 09:08:59 / ---> seperator, e.g. {0:dd/MM/yyyy} ---> 08/04/2007 

This worked great for me greatly... This will work for you as well

like image 164
user2331781 Avatar answered Sep 29 '22 02:09

user2331781


DateTime.Now.ToString("yyyyMM"); 

Documentation on DateTime Format strings is available here.

like image 21
alexl Avatar answered Sep 29 '22 03:09

alexl