Userform Field Month and Date.

Status
Not open for further replies.

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Is there a way to create a new userform field for my contacts where it is only a month and a date and for example , if i type in 9/20 it shows up as September 20 and nothing else shows up. So is there something go to in creating form or is there a formula to put in the form that does it?? Thank so so much as I would like to get this done very very soon.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
You can create a text field, create a date/time field linked to it and choose from various date formats. if you type 9/20, it will format it as September 20 when the form or page is refreshed.
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
What format so it does not show the year. What showed shows the day and month but not clear what format?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
It's on the control's Value tab if you created a date/time field.
date-format.png
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
I did it and when i put in 9/20 it shows up as September 14
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
OPh. You'll need to use a second field of the formula type- this formula should work (txtDate is the date in the first field.)

IIf( [txtDate] = "None" , "" , Format(Month([txtDate]),"MMMM") & " " & Day([txtDate]) )
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Thanks much. I am confused. Do I create one field which is just a text field and then create a second field as a date/time field, link the first field that is in my contact form to the second field as you showed that, but put a formula in the second field when I create and the following formula?

IIf( [txtDate] = "None" , "" , Format(Month([txtDate]),"MMMM") & " " & Day([txtDate]) )
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
You need two fields - one that holds the original value and one that displays the formatted value. If this is their birthday, you can use the birthday field in the formula instead.
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Thanks ..I am on my computer to finish this....is it possible for you to write down exactly how I create what you say and which field I put in the contact form?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
FYI, the correct formula is this, the format function isn't used.
IIf( [txtDate] = "None" , "" , Month([txtDate],"mmmm") & " " & Day([txtDate])) - you don't need to use Format.

Dang, embedded videos won't work. :(
http://www.screencast.com/t/Drc1WL4K
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
I don't know how to create anything in this areas and where to put whatever you say....can you please explain?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Create a custom field - a label will work or text box if you disable editing in it's Properties. The formula has the other field name -

IIf( [otherfield] = "None" , "" , Month([otherfield],"mmmm") & " " & Day([otherfield]))
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
So I create the first field with the Name: MonthDayField, the Type: is Text and the Format: is Text.

Then I create field with the name MonthDayField2, the Type: is Formula and in the Formula: below, is past the words: If( [MonthDayField] = "None" , "" , Month([MonthDayField],"mmmm") & " " & Day([MonthDayField])) , and it said Functinon cannot be found.
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
And what type of the Date field as you can decided what type of words and numbers?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I'm not sure how you'd get the wrong # of arguments by creating a custom field of the Date type?
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
I did the first field as a date and in Type selected date/time and the next line below selected March 15, 2014.

So when I created the second field using your formula, thats the error.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
A Outlook Userform Size Outlook VBA and Custom Forms 2
N Activity Tracking with Userform Outlook VBA and Custom Forms 4
D Next Available Meeting with Userform Variables Outlook VBA and Custom Forms 1
A Populate Excel from Outlook Userform Outlook VBA and Custom Forms 3
B Insert Hyperlinks for attachments in Userform Outlook VBA and Custom Forms 5
D Change sender name outlook vba 2010 Custom Userform Outlook VBA and Custom Forms 1
A Open CHM file from VBA Userform Outlook VBA and Custom Forms 4
L Outlook 2007 - Userform Using Outlook 2
A Focus on the userform Outlook VBA and Custom Forms 15
F Outlook 2010 - outlook userform and combo boxes Using Outlook 9
witzker insert Date & Time (HH:mm) no (ss) in userform Using Outlook 6
A insert Date & Time in userform Using Outlook 3
X VBA: Confused with variables between ThisOutlookSession and UserForm Using Outlook 1
L UserForm Code For Contact Links Using Outlook 76
M Progrescreas Bar in Outlook UserForm Using Outlook 1
C UserForm and ordering variables Outlook VBA and Custom Forms 3
J userform combobox Outlook VBA and Custom Forms 1
R combobox list in userform Outlook VBA and Custom Forms 1
B Userform Outlook VBA and Custom Forms 5
W Using Excel UserForm from Open Workbook in Outlook VBA Outlook VBA and Custom Forms 5
P userform in VBAProject.otm not working Outlook VBA and Custom Forms 1
S Create a clickable custom column field Outlook VBA and Custom Forms 0
B User defined field for messages with 'me' in the [To], [Cc] line Using Outlook 0
V Limiting text length in free text field Outlook VBA and Custom Forms 2
C Outlook 2016 Conditional Format for User Defined Field Using Outlook 1
C Copy Outlook contact field value to another field Outlook VBA and Custom Forms 1
A new labeled phone field Using Outlook 4
V Making a Date field mandatory in outlook form Outlook VBA and Custom Forms 2
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
BretAB Is it possible to add a lookup field to a Message form? Outlook VBA and Custom Forms 4
N Exporting IM Address field Using Outlook 2
M Using field names to capture a data element Using Outlook 0
J How to restore field no longer visible in field chooser? Using Outlook 1
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
R What's supposed to appear when just clicking into the search field? Using Outlook 7
A Missing context menu on Location field Using Outlook 2
G Entered data in custom field goes in card and does not stay in list view Outlook VBA and Custom Forms 1
C Changed By field not displaying individual user's name in O365 Shared Mailbox Using Outlook 9
M Making Subject field writable (disable Read Only) Outlook VBA and Custom Forms 2
C Import Outlook 2016 contacts into to: field Using Outlook 1
T Source of Outlook 2016 Address field dropdown "Other Suggestions" Using Outlook 3
S BCM Compulsory field, New opportunity Outlook VBA and Custom Forms 0
M Sudden change in From field - now very short Using Outlook 4
L Automatically Insert Recipient Name from To Field Outlook VBA and Custom Forms 33
J Assess content of User Defined Field in Rule Using Outlook 3
K Contact notes field replicating Using Outlook 6
G Copy Contact field to Appointment Custom Form Field Outlook VBA and Custom Forms 2
Caio "From" field doesn't show extra email addresses in Outlook 2016. Using Outlook.com accounts in Outlook 6
T "From" field font size in table list of emails Using Outlook 0
skyfox VBA to search email subject field for a certain string Outlook VBA and Custom Forms 3
Similar threads


















































Top