|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
February 12th 10, 10:44 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Need leading zero for month number is less than 10
I need to show month of the Received column in the row view with a leading
zero if the number of the month is less than 10. Today February 12, 2010 should appear as 2010-02-12. I created a calculated field with the formula year([Received]) & "-" & month([Received]) &"-"& day([Received]) However, it shows as 2010-2-12. I can plug in a zero before the month, but if I do that, I will get 2009-012-12 if I look at something in October, November or December and I do have those in emails in 2009 in this project. 
|
| Ads |
|
#2
February 12th 10, 11:03 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Need leading zero for month number is less than 10
You know you won't be able to sort on a calculated field, right? Is there a
custom form involved? What's your business goal here? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "alex20850" wrote in message ... I need to show month of the Received column in the row view with a leading zero if the number of the month is less than 10. Today February 12, 2010 should appear as 2010-02-12. I created a calculated field with the formula year([Received]) & "-" & month([Received]) &"-"& day([Received]) However, it shows as 2010-2-12. I can plug in a zero before the month, but if I do that, I will get 2009-012-12 if I look at something in October, November or December and I do have those in emails in 2009 in this project.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Allow user-defined number of weeks in Outlook 'Month' view | lv0865 | Outlook - Calandaring | 6 | December 30th 08 07:55 PM |
| Change month identity from number to name, ie 5 to May | Chet in Colorado | Outlook - Calandaring | 1 | June 17th 08 05:31 AM |
| How can I change the number of weeks in month view in Outlook? | benltan | Outlook - Calandaring | 11 | June 16th 08 09:53 PM |
| Number of weeks in month view | Fred M | Outlook - Calandaring | 1 | September 5th 07 11:07 PM |
| changing the number of month to view on calendar | jd | Outlook - General Queries | 1 | May 26th 06 02:22 PM |
Linear Mode
