Format Month Number To Name

To do this, select the cell containing the date or time value, call its context menu and select Format Cells. To apply a custom format: Select the cell to be formatted and press Ctrl+1 to open the Format Cells dialog. We can exploit this use of the MONTH function to create a date serial number (shown in column C below). This tutorial describes how to easily get your own US phone number from anywhere in the world for free. date_optional_time or strict_date_optional_time A generic ISO datetime parser where the date is mandatory and the time is optional. MonthName function helps to generate name of the month from specified month number. In my case the number three will be built into a concatenated string such as "2018-3-1". R contains a set of object types for holding date and time information. Data Type Formatting Functions. Convert dates to weekday/month/year name or number with Format Cell ; Convert dates to weekday/month name with TEXT function; Convert a date to weekday/month name with CHOOSE function. its inserting month number into my database but i want display month name in my view ? using Carbon or anything ? EX : in my Database i have column call date from this form i can insert number only 7 but i want to display July. Makes the appearance of the date components (day name, month number, and so forth) depend on the NLS_TERRITORY and NLS_LANGUAGE parameters. This article provides a guide to make your data model compatible with the new forecasting feature. Nth Day Of Week. Using this you should be able to display the date format you want , or send through a particular format to a Stored Proc. Translate the Date(). format() for great good! Python has had awesome string formatters for many years but the documentation on them is far too theoretic and technical. Prevent Excel from reformatting two numbers to a date and month. Using Custom Data Format feature we can change the masks for numeric values, change the display of null values or show dates in custom format. MS Access: MonthName Function This MSAccess tutorial explains how to use the Access MonthName function with syntax and examples. ©2017, Communities Digital News, LLC. However, advanced settings Long Date Format (F5 key), Short Date Format (Shift+F5 key), Day Date Format, and Time Format can be used to control the format of the date and time. Write the journal's publication date. QT: Quick Tips, formerly known as Coders Corner. The last name and salary for all employees with the format of the salary 15 characters long, left-padded with the $ and the column labeled SALARY. For input format models, format items cannot appear twice, and format items that represent similar information cannot be combined. Like this: =MONTH(DATEVALUE(B1&"1")). The month function returns the month numbers or names of datetime values. Similarly, you can get the name of the day by just changing the format to “DDD”, “DDDD”. Native XSLT 1. In a query, I use the "Part" function DatePart("m",[full_date]), to extract the month (number) and all month extracts worked correctly (they returned the correct numerical month). “Title of Web Page. You only want to replace the month number with cell reference as above. The general structure of a D3 number format is %B - full month name. Once you have your name number, you can look up that number in a numerology chart to find out more about yourself. For example, this. The tutorial explains Excel MONTH and EOMONTH functions in full detail. This works because MONTH returns a number 1-12 that corresponds to the month name. 16, “MySQL Server Locale Support”). There is different conversion function which used to convert one form of data into another format. Numbers which have more digits to the right of the decimal point. The FORMAT() Function The FORMAT() function has been available since SQL Server 2012, and it's the most concise way of returning the month as a 3 letter abbreviation. In order to convert the number to month in text format to show the name of month, use the following function in the cell which the name of month should be displayed; =TEXT(DATE(2010, A1, 1), "mmmm") Where 2010 is a dummy year, A1 is the cell number where the month number is located, and 1 is dummy day. is there a direct formula for the same?. tuesday january 6 2015. Dates can be provided to the function by using another date function, by using an expression that returns a date, or by typing a date in a datetime format. Steps: Add a new column that represents the intended sort order (ex: Jan = 1, Feb =2). This resource, updated to reflect the MLA Handbook (8 th ed. Post subject: Re: How to convert Number into Month? Are you on XIR2 SP2. Specify the date and/or time format patterns that this field can use. If your data were exported from Excel, they will possibly be in numeric format. There are two common scenarios where this can be useful: You have a column of month values entered as text, and you want to sort the list by date order rather than by alphabetically by month name:. ), offers examples for the general format of MLA research papers, in-text citations, endnotes/footnotes, and the Works Cited page. Gregorian dates follow the same rules but tend to be written in the yyyy/m/d format (Day first, month number, and year in right-to-left writing direction) in Arabic language. IJIRT Search Xplore - Search by Paper id, Published paper id, Paper Name, Author Name and Paper Title Search Your Paper Details. m = month(t,monthType) returns the type of month number or name specified by monthType. get previous month name. Year come out as simple ints, and putting them together in what looks like a date doesn't make it one. Here is the output screenshot for your reference. Biz: Your Resource for Phone Number Lists. Articles differ from book citations in that the publisher and publisher location are not included. Details about today's date with count of days, weeks, and months, Sun and Moon cycles, Zodiac signs and holidays. Learn C programming, Data Structures tutorials, exercises, examples, programs, hacks, tips and tricks online. Boolean value that indicates if the month name is to be abbreviated. getDisplayName(Calendar. Click Control Panel. Code for Convert to Month _Number Click a Data View in left side of Power BI and shown the Dataset Create a new column of this dataset(eg: Column_name:Month_Number). All dates other than the first of the month will be greater than 1, so all will produce the result " False ". Format 12 is the Julian day number expressed as a floating point value. A3: July 1 You can format the date as. in this how should i do this. However, when I attempted adding a field in the query to format that extracted month to a month name, it only returned January and December - for all 200+ records. In the upper left-hand corner of the first page, list your name, your instructor's name, the course, and the date. Date is saved as number internally in db which no user may be able to understand. ), offers examples for the general format of MLA research papers, in-text citations, endnotes/footnotes, and the Works Cited page. This is an ideal approach to deal with multiple conditions. A report I’m running gets the data for the last Month. Use the DateAdd function in the formula to get the date minus one month: This says to use “month” intervals, subtract one, and use the current date as the starting point. If we would not use format function, SAS would display the date in SAS datevalues format. S = datestr(S1, F, P) converts date string S1 to date string S, applying format F to the output string, and using pivot year P as the starting year of the 100-year range in which a two-character year resides. (By using case,I got it) But is there any other simplified way to do that. All you need to do is sort the 'Month Name' column by the 'Month Number' column. For example, you may need to concatenate a first name and a last name to a full name, extract part of a product number, convert the data format or multiply two numbers. Solved: My month column is like below and I try to convert the month name to 2 digit number by using formula function. Month number to Month name Basically in my Sales. AbbreviatedMonthNames property. Date Conversion : Month Name --> Number Hi, I have a script (Bash) that grabs a month from a specific file, however in that file it is listed as a name rather then a number (April May June etc. VBA provides two functions for formatting a date string to present it to the user. At the report front end, I can alter the format of the datetime which will give the Month, but I need to create an attribute to extract the month so that I can use it as a filter in various reports. Writes international date values as the name of the day and date in the form day-of-week, dd month-name yy (or yyyy) HHMMw. How to Change Number Format in Excel (+Custom Formats) Written by co-founder Kasper Langmann, Microsoft Office Specialist. number_of_bits is silently clipped to 64 if larger than 64. Dec)? For example: 1 as Jan 2 as Feb etc. For any format pattern letter that returns a numeric value (for example, w, h, and m), the number of letters in the format pattern represents the minimum number of digits. What is the syntax to get the current month name (e. 2) Use a Case Statement. Here’s the simplest way in my opinion: DECLARE @Mth smallint SET @Mth = 11 SELECT DateName (mm, DATEADD (mm,@Mth,-1)) as [MonthName] OUTPUT. Format you are simply putting together two ints to make a date string. (2 replies) How do I build a query that takes a field containing the number of the month (1, 2,. See screenshot: Method 1: Convert month name to number with formula. Get the names of the month. A single-digit day is formatted without a leading zero: dd: Represents the day of the month as a number from 01 through 31. Some of you might be familiar with some of this already, however it is always good to have a blog post out there that lists them all for future reference. In this class, BCE years are counted astronomically. NET Framework Also discuss all the other Microsoft libraries that are built on or extend the. Type this formula  =MONTH(DATEVALUE(A1&” 1″))  (A1 indicates the cell that you want to convert the month name to number, you can change it as you need) into a blank cell, and press  Enter  key. Post subject: Re: How to convert Number into Month? Are you on XIR2 SP2. Let us have a quick glance look at the solution. To use, copy to a plain text file and save as date. When I grouped by month and year, it shows the year in a row above the month names. The Long Date format shows a preview of the date and includes the name of the day for the date in the selected cell. You can no longer post new replies to this discussion. 0) to : MonthName Function in VB Script (VBS) MonthName Function in JScript (JS) MonthName Function in ASP (Active Server Page). Well, that’s my current approach. But many users are not aware how to use month in Query. The TEXT function converts a value to text in a specified format. Name of month, three-letter abbreviation. The full month name according to the current locale. So before going to our tutorial on how to convert Month in Number to Month Name in Text in Google Sheets, I suggest you to go through my earlier tutorial that follows. Using =TEXT formula, easily Convert Month Number to Month Name and Day Name. Add the Monthly Compensation, Hiring Date in mm/dd/yyyy format and the position. How can I get the month name from the month number. Month function has returned the month number of the year. String Format for Int [C#] Integer numbers can be formatted in. Note this JavaScript built-in time function returns a numerical value between 0 and 11; where 0 corresponds to January, 1 corresponds to February, 2 corresponds to March, and so on. A number format pattern is a string of token substrings that, when parsed, are replaced with the corresponding number representations. To do this, simply use MMM (three M s instead of four). Month and p. Non-English Word. In this approach, we…. Get the Last week Number, Sunday date & Monday date for the given Year and Week number. This macro expands to the name of the current input file, in the form of a C string constant. This is working fine for Month Number on the X axis, using a calculated column simply as MONTH([Date]). Be sure you capitalize the first letter of each day and month. By default it is set to False. 3)Click on formula and enter the formula you had wirtten or add the month name in that. -R, --rfc-2822: Output date and time in RFC 2822 format. getMonth() to month name: java2s. If this parameter is set to FALSE, the month name is not abbreviated. Date Conversion : Month Name --> Number Hi, I have a script (Bash) that grabs a month from a specific file, however in that file it is listed as a name rather then a number (April May June etc. The following methods can help you easily convert or format any kinds of date to display only the weekday name or month name in Excel. This when run gives the date displayed as month name. So, by popular demand, we've created a few different printable checklists along with some checklist templates that you can edit in Excel. Search Your Paper. For example, if the count of 'y' is 2, the year will be displayed as the zero-based year of the century, which is two digits. 1 report functions and will describe each & every functions along with example. This “Sort by Column” concept can be applied to sorting other columns as well, but the application for month names / month number is the majority case that I’ve seen. %A Locale’s full weekday name. I am trying to do this in design mode if possible. The Python docs contain all the format codes that the C standard (1989 version) requires, and these work on all platforms with a standard C implementation. Day of the month as a decimal number, includes a leading zero. Trouble is, Month Name fields are text fields, and therefore Power BI has no choice but to sort them alphabetically. Excel formula to get week of month - posted in Formulas and Functions: Im trying to create a formula to extract the week number of a date within the month. It then converts the number to a message that will be printed (Copy the program to see it yourself). In Calc, when I click Format -> Cell -> Number, and select MMMM as th format for a date, the output is janvier, without a capital letter. I can't get the formatting to work in the DisplayFormat and GroupFormat properties. For example, the MONTHw. If you have a question you can start a new discussion. Team India officially donned their new jersey for the first time on 22nd August against West Indies for the Antigua Test. Now select 'no' to display years,weekdays and days. Learn about all the supported format specifiers, applicable flags, alternative output. Clean CARFAX. to change my column of month numbers into the actual month names, but it spits out 1899-12-30 12:01:00 AM, which I'm guessing is Tableau's epoch time? Ultimately I'm using a combination of Month# and Week# as pages, so the end user can visualize Running Sales over a Month in relation to the Goal, at the singular week level. RM: Roman numeral month (I-XII; JAN = I). Here, I will explain the syntax and examples for those conversion functions. Maclean's, 113, 36-40. Instead of August, the month name is dispalyed as January. I'm noob in Java but i found this one… calendar. string functions ascii char charindex concat concat with + concat_ws datalength difference format left len lower ltrim nchar patindex quotename replace replicate reverse right rtrim soundex space str stuff substring translate trim unicode upper numeric functions abs acos asin atan atn2 avg ceiling count cos cot degrees exp floor log log10 max. What is the syntax to get the current month name (e. that showing month name and year which pull from posting date. Here Month function is used to display month number. How should i convert the month name to month number like 'April' it should converted to 4 'January' it should converted to 1. ); run; proc print ; run; Message 9 of 10 (17,004 Views) 4 Likes. A Date/Time field is actually stored as just a number, a count of days and fractions of a day since midnight, December 30, 1899. EDATE(, ) Returns the date that is the indicated number of months before or after the start date. By default it is set to False. If you choose “MMMMM”, you will get M (first letter of the month name). If necessary, SAS truncates the name of the month to fit the format width. One of the frequently used EXCEL formula to convert date to Weekday Name Or Month Name or year is TEXT Function. how to get month name and month number from a given date of TransDate type? Verified i have a date of transDate type and i want the month name in string format and the month number. jan week number of the year with Monday as the first day of. Output date/time in ISO 8601 format. ? Example : suppose the input is December 20,2006 I want to get it converted to SAP internal format YYYYMMDD i. The example table uses the input value of 18031, which is the SAS date value that corresponds to May 14, 2009. If you specify multiple patterns, separate them with line breaks. and i also have to sort the month with aprial as the first month and march being the last. One may want to extract the month or the year component from this variable. Datetime Format Elements. In this tutorial, you learn exactly how to use the ‘TEXT’ function in Excel. Advanced HTML For Beginners > Forum > Code Forum > HTML Forum > HTML codes for todays date?? If this is your first visit, be sure to check out the FAQ by clicking the link above. ENGLISH) this actually returns You string with name of the month in English that You desire 🙂 works for me (change from my language to English). Click Regional and Language Options. Month number to Month name I'm looking for a way to convert Month numbers to their three-letter names. Month function has returned the month number of the year. Format number to month name in chart I would like to create a slider chart to select a month name (jan->dez) with a static step of 1. I am Unable to Sort the Order By by Month names in MS Access Database I am Using the Format Function to retrieve Month Name (If I use MonthName(Month(date)) Function The Query is Executing at. Press the key Ctrl+1. How can I get the month name from the month number Python Programming. Like this: =MONTH(DATEVALUE(B1&"1")). Some of the more commonly used date functions extract the day of the week, the month, or the year from a SAS date value. PERIODID, -1 )) You can see how to do this without writing code using Crystal Reports and SSRS in the May issue of our GP Reports Viewer Newsletter. If given just the month number, however, you must first convert the number into a valid date format and then you may use the FormatDate() function to convert the date into your …. Here is the output screenshot for your reference. Hi there, I have the following problem, I have a list of dates with the following format (in the string): "07 July 2004" I want to transfer this into a date (07. Start your free month. Get Days in Month using Month Name Let's say you have entered a month's name in a cell not a proper date and now you want to calculate total number of days from this month. The lowest date which Excel can store is 1-Jan-1900 which has a number 1. Find the time difference between two date/time. If you select Format -> Custom , and enter : [$-426]mmm you will get Mai ; changing the format to : [$-409]mmm will display May. I am trying to do this in design mode if possible. For any format pattern letter that returns a numeric value (for example, w, h, and m), the number of letters in the format pattern represents the minimum number of digits. But: Using the three Ms next to each other may be easier and clearer for your code. The format can be combinations of the following: d - day of month (no leading zero) dd - day of month (two digit) o - day of the year (no leading zeros) oo - day of the year (three digit) D - day name short; DD - day name long; m - month of year (no leading zero) mm - month of year (two digit). Formats 2 through 10 may be optionally followed by a timezone indicator of the form " [+-]HH:MM " or just " Z ". If you change the number or location of rows then you will need to change the parameters that is driving the For Loop. Middle Initial. Press the key Ctrl+1. Loading Skip to page content. I have seen scores of expert developers getting perplexed with SQL Server in finding time only from datetime datatype. You're going to have to finish/fix it and add the elseif to the "if" case to alert user to the invalid month. Method 1 : In this method, we will use the Old approach. In this article I will provide some examples on how to deal with custom data formatting for numeric values, dates and null values. Format you are simply putting together two ints to make a date string. Calculate the day number and week number of a given date. and i also have to sort the month with aprial as the first month and march being the last. Using this you should be able to display the date format you want , or send through a particular format to a Stored Proc. purchase_date as month format=MONNAME. Tips : Dates Calculations - Current Month, Previous Month, Next Months (add or substract 1 month, first date of months, day name, day number 0,1. I have a data item called [NUMBER OF MONTH] which displays the number of the month the report is about. The step was taken to popularise Test format among young audiences further. Parameter Description; month: Required. Available as Adobe PDF and Microsoft Excel documents. Whether you were intentionally named with a numerology result in mind or your name number is by chance, knowing your number sign can perhaps give you some insight into your personality. jan week number of the year with Monday as the first day of. This macro expands to the name of the current input file, in the form of a C string constant. Day of Year Program // This function displays the month and day using * // the number entered 365}; //Set the name of each month into an. Luckily, Microsoft Excel provides a special MONTH function that can change a month's name to a month's number: =MONTH(serial_number) For the MONTH function to understand it deals with a date, we put it like this: =MONTH(1&C2) Where C2 contains the name of the month, January in our case. You only want to replace the month number with cell reference as above. Power BI Natural Sorting of Month Name As you may already know, it's super easy to build a chart in Power BI , but it is not so intuitive when it comes to natural sorting of month names. DAY: Returns the day of the month that a specific date falls on, in numeric format. 12) and displays it as the name of the month (Jan, Feb,. Standard formats only work when they are used alone. Check out our new reputation system. The author and Communities Digital News owns the whole copy write of this article and it may not be duplicated without express permission. This is an ideal approach to deal with multiple conditions. It could be the month of the first day of each week number. Similarly if you want to list all the month names for a year using a T-SQL statement, you can do this:. Instead of August, the month name is dispalyed as January. Depends on NLS-settings. The need to manipulate them arises frequently in computing, especially in web development. Boilerplate is basically that blurb at the end of a news article that describes the subject of the article in a neat little tie-together. N: Returns the argument provided as a number. an abbreviated format from the "Acceptable date formats" table, provided the day and month elements are in the same order as in dates in the article body, or the format expected in the citation style being used (however, all-numeric date formats other than yyyy - mm - dd must still be avoided). The Python docs contain all the format codes that the C standard (1989 version) requires, and these work on all platforms with a standard C implementation. and i also have to sort the month with aprial as the first month and march being the last. Using =TEXT formula, easily Convert Month Number to Month Name and Day Name. convert month number to month name; Month to month yearly results - hard and slow help converting month number to month name; Convert Month Number to Month Name in Report based on query; get the month (number) and year value from a date; Figure out month number from month abbrievation; convert dec number to HEX and oct and bin without c. Let’s learn this with an example. Can you suggest me a function module which would convert the month name to the month number. %A Locale’s full weekday name. In this example, the format elements are: DD represents the day, Mon represents the abbreviated name of the month, YYYY represents the 4-digit year, and the character string literal '-' represents the hyphen character. What I understand with your question that you want to convert 1 to Jan which can be done using format. Getting Name of the Month by entering month number We can get the months name by using the month number by using MonthName() function. Excel DAX - Working with Text and Dates - DAX can be used in the scenarios involving working along with text, extracting and composing date and time values or creating values based on a condition. ) abbreviate: Optional. Configuration. This article explains how to improve DAX queries using GENERATE and ROW instead of ADDCOLUMNS when you create table expressions. How to format DateTime in GridView BoundColumn and TemplateColumn?,Most often, we will get requirements to display date in GridView column. 16, “MySQL Server Locale Support”). to change my column of month numbers into the actual month names, but it spits out 1899-12-30 12:01:00 AM, which I'm guessing is Tableau's epoch time? Ultimately I'm using a combination of Month# and Week# as pages, so the end user can visualize Running Sales over a Month in relation to the Goal, at the singular week level. Print number of days in month using switch case in C. Yet, the application also offers the ability to create custom number formats. Web Sites Format: Varies depending on what type document it is. 0 forces display of zeros if a number has fewer digits than the format specifies. Any help on how to use this would be appreciated. tuesday january 6 2015. Convert Month text to Number With "mm" Format will return a STRING that is two digits. Select yes to display months. The user could enter it in the form of first name followed by last name (e. getMonth() to month name: java2s. Can you suggest me a function module which would convert the month name to the month number. 2004) but I have no idea how to transfer the extracted month name (July in this example) into a number (07). Thanks for your ideas. It's a big step for the year-old Viacom unit as it tries to. Write the title in Title Case (standard capitalization), not in all capital. cnsuman, Your original question: "I WANT TO CONVERT THE MONTH NUMBER ENTERED AS A PARAMETER TO MONTH NAME IN A COLUMNHELP PLZ" So, user typed in 12, you want to show in the report textbox as December, right? Simply use =MonthName(Parameters!mthnbr. Here is the syntax for MonthName function. Write your signature just beneath your closing and leave four single spaces between your closing and your typed full name, title, phone number, email address, and any other contact information you want to include. Week number in a Month this is the best code a found. Try SciENcv, a tool supporting multiple research agencies, to help you develop your biosketch and automatically format it according to NIH requirements. I made a pivot table in another spreadsheet tab. The first thing you should notice is that all custom number formats follow a basic syntax:. If you do not want to see this type of numerical date or time representation, change the number format (date or time) accordingly. You can find output in an immediate window. Hi all I have a multiple datasets that look like this MM Freq 1 30 2 35 3 54 4 33 5 27 6 13 7 25 8 29 9 40 10 32 11 36 12 23 I am plotting this using barchart (there is probably something better but it gives me the results I want) and I would like the x-axis to have the names of the months instead of the month numbers. format() for great good! Python has had awesome string formatters for many years but the documentation on them is far too theoretic and technical. So it should not be possible to move the arrow between 2 month. Jan, Feb, Mar etc. Month name spelled out (January - December). Ran into a problem with Excel and dates, I have the month name (as Jan-Dec), and I need to convert it to the month number using a formula, is there any way to d Excel convert Month Name ("MMM") to Month number (1-12) - Microsoft: Office - Tek-Tips. You only want to replace the month number with cell reference as above. Hi all how to get date format from known month and year in sql server eg: i have to form a date using month 5 and year 2011. The basic structure is: Journal Article Examples: Mitchell, J. SELECT DATENAME(month, DATEADD(month, GL. In the upper left-hand corner of the first page, list your name, your instructor's name, the course, and the date. When I say "date in a file name" I mean that the actual title of the file has the date in it. Month function has returned the month number of the year. HRAR_SUBTRACT_MONTH_TO_DATE. is actually stored as. GetYear: Returns the year number of the specified date. There will be a box somewhere in there to let you mess with the axis formats. Get month name from integer VB. Excel DAX - Working with Text and Dates - DAX can be used in the scenarios involving working along with text, extracting and composing date and time values or creating values based on a condition. and i also have to sort the month with aprial as the first month and march being the last. So, power query is a complete pack for you to work with dates. Returns the month as an integer for the given date value. In your Power Query Window, click on Add Custom Column and then put in the following syntax. I’ve collected a list of formats from the Powershell help text and other locations and put them in a big text file which looks like this:. Add months to. Solved: Convert a month name to a month number If this is your first visit, be sure to check out the FAQ by clicking the link above. Using =TEXT formula, easily Convert Month Number to Month Name and Day Name. For journal articles, these are replaced with the journal title, volume number, issue number and page number. Now select 'no' to display years,weekdays and days. format writes the month (1 through 12) of the year from a SAS date value. "1&" is added to concatenate a date (1 January) so that. How do I get Month Names to show up in my Pivot Table? After a lot of tweaking I managed to get the Number of the Month to display- For about 40 minutes I hassled with this to stop it from displaying each individual day. A few days ago, I wrote an article about Multiple ways to convert month number to month name. Hi, Can anyone please advice on how to convert a date to the format as Month name and year(2 digits). Format or instance method int. TH : Converts a number to it's ordinal format. For formatting functions, if the date or time has fewer digits than the number of pattern letters, the output is padded with zeros. After payment confirmation, all completed forms will be processed, starting October 5 and you will receive your DV-2021 Program Certificate of Registration and your Unique Identification Number via email. Thanks and regards, Thimuth How to match three letter month name in Hive queries. Also paste the exact expression used to show month names and check the datatype of month_no column. For example, this. ToString(DateTimePicker All About Machine Learning Why Join Become a member Login. Join a community of over 2. PyFormat Using % and. The easiest way to see the weekday name is to select the cell, then press the Number Format Drop-down menu button on the Home tab of the Ribbon. Convert From Month Number to Month Name Hi, I have a script that accepts an input date from the user in yyyy-mm-dd format. m = month(t,monthType) returns the type of month number or name specified by monthType. The Long Date format shows a preview of the date and includes the name of the day for the date in the selected cell. The basic citation format includes: Organization or Author's Last Name, First Initial. The fullest format is full day name and number, full month name and 4 digit year, e. My input for query is 'Jan-2010' it should give me output as '01-2010'.