Displaying Date Value In Formula

Post number 5 has been selected as the best answer.

S

srmsrm

Senior Member
Outlook version
Outlook 365 64 bit
Email Account
IMAP
Using Outlook 365 Apps for business. Using latest version as on July 1, 2023.

I have a text field, using the Value property that I want to show values for other custom fields I created. The below seems to work OK using the calculate this formula automatically option selected.

[Program Purchased]+Chr(10)+[License Type]+Chr(10)+[Serial Numbers]+Chr(10)+[Renewal Cost]
1688229838011.png


1688229861579.png


When I add in the value for the date field [Renewal Expires], all the data disappears from the display.
[Program Purchased]+Chr(10)+[License Type]+Chr(10)+Chr(10)+[Serial Numbers]+Chr(10)+[Renewal Cost]+Chr(10)+[Renewal Expires]
1688229846977.png


1688229955571.png


If I show only the [Renewal Expires] in the formula, the date value does appear
6/30/2023 8:00:00 AM

1688230097023.png


1688229873312.png


I have tried other date fields (including the default reminder time) with the same results. Is there something with date values required to display in a formula with other fields.

Thank you.

Shawn

1688229803422.png
 
Last edited:
The field only supports joining text.

I don't think you can use Test:
TEXT([Renewal Expires],"MM/DD/YY")

If not, try this:
Month ([Renewal Expires]) Day([Renewal Expires]) Year([Renewal Expires])
 
Diane Poremsky said:
The field only supports joining text.

I don't think you can use Test:
TEXT([Renewal Expires],"MM/DD/YY")

If not, try this:
Month ([Renewal Expires]) Day([Renewal Expires]) Year([Renewal Expires])
Click to expand...

Diane

Thank you for your help. Unfortunately, I cannot make either of the above options work.

I do not understand why the date displays but itself but not with other fields.

Do you think I should I create a new field such as Combination or Formula to show the data?

Shawn
 
Yes, try combination.
 
Diane Poremsky said:
Yes, try combination.
Click to expand...

Diane

I got it to work using a Combination Field. Thank you. I appreciate your guidance.

Program Purchased: [Program Purchased]
License Type: [License Type]
Serial Numbers: [Serial Numbers]
Renewal Expires: [Renewal Expires]
Renewal Cost/Notes: [Renewal Cost]

Program Purchased: Program Name
License Type: License Type
Serial Numbers: Serial Numbers
Renewal Expires: 7/12/2023 1:23:00 PM
Renewal Cost/Notes: $Cost

I found this article Examples of Formula and Combination Fields (might not be a valid reference), but I cannot locate an option to customize the display of the date field:

Renewal Expires: [Renewal Expires]
Displays as: Renewal Expires: 7/12/2023 1:23:00 PM
Would like for it to display as: Renewal Expires: July 12, 2023

Is that possible?

Shawn
 
Normally you would use Format but that does not work in that field.
 
Diane:

Thank you.

I did try Format, but I thought I was missing something since it was not working. Thanks for your help and feedback.

Take care.

Shawn
 
You must log in or register to reply here.
< Adding Custom Forms | Strange VBA error >
Similar threads
Thread starter Title Forum Replies Date
J ol2021 custom form not displaying pics Outlook VBA and Custom Forms 37
L Images not displaying in emails sent to self Using Outlook 2
J custom form not displaying pictures Outlook VBA and Custom Forms 7
HappyDaddy007 "Size" on field chooser/column displaying incorrect value Using Outlook 3
L Email with correct To address but displaying name of a related person Using Outlook 0
C Changed By field not displaying individual user's name in O365 Shared Mailbox Using Outlook 9
Y Outlook not displaying all imap emails Using Outlook 5
N Signature displaying incorrectly in email Using Outlook 1
S Show Total Number Of Items Not Displaying Using Outlook 9
J Subject Field is displaying Name and company Outlook VBA and Custom Forms 1
M Contacts list not displaying Using Outlook 10
V Not displaying newest messages in Inbox Using Outlook 10
C Unread email count not displaying on Inbox sub-folders Using Outlook 0
Diane Poremsky Displaying a Picture on a Contact Using Outlook 0
N Outlook Forms Not Displaying Outlook VBA and Custom Forms 6
K Outlook 2010 form is displaying old form layout Using Outlook 3
C Displaying Profile Pictures in Outlook 2010 Using Outlook 3
S Custom Outlook Form 2013 Displaying fields incorrectly Outlook VBA and Custom Forms 1
T Displaying Shortcuts in Outlook 2010 Using Outlook 7
Digitally Hip Outlook 2010 (32) and Exchange 2010 (sp3) sender info not displaying in Outlook Using Outlook 1
N Grid Lines Not Displaying - Outlook 2013 Using Outlook 3
Sarge USMC Outlook 13 not displaying POP inbound emails Using Outlook 12
W Outlook 2010 - Displaying Private Appointments In Shared Calendars Using Outlook 1
G Outlook Intermittent Issue with Drafts not Displaying Entire Content Using Outlook 4
M View in browser stopped displaying .GIFs in Outlook 2010 Using Outlook 1
T To: and Cc: not displaying when forwarding/replying to .eml files Using Outlook 4
E BCM Contacts & Accounts not displaying correctly BCM (Business Contact Manager) 2
S Displaying the Remind Beforehand Value in Calendar List View Using Outlook 2
wallisellener Marketing and Project Management field are not displaying BCM (Business Contact Manager) 2
R Outlook 2007 not displaying embedded images in emails Using Outlook 1
S Holidays after 2012 & NOT displaying location Using Outlook 8
J Remove location field from displaying Using Outlook 8
O Exchange 2003 displaying HTML emails as having attachments Exchange Server Administration 7
B Sent Items Not Displaying in Outlook 2010 Client Using Outlook 2
V Outlook 2007-Tasks not displaying in calendar Using Outlook 4
S Outlook 2007: Shared Tasks not displaying on my To-Do Bar Using Outlook 8
G Displaying value of task subject field as values from two custom fields Using Outlook 4
K Outlook 32-bit Connector and Outlook not displaying the folders Using Outlook.com accounts in Outlook 10
T VSTO Outlook add-in: Categories not displaying correctly Outlook VBA and Custom Forms 3
I Displaying my Online/Offline Status BCM (Business Contact Manager) 2
R Displaying a field from the field chooser programmatically Outlook VBA and Custom Forms 1
W Displaying custom properties of a PDF DocumentItem Outlook VBA and Custom Forms 3
L Deleted items not displaying in outlook Using Outlook 2
S Olk2003 displaying an error message Outlook VBA and Custom Forms 6
J Suppliers in Accounting 2009 not displaying in BCM BCM (Business Contact Manager) 2
F Outlook 365 Group INBOX by date but not by date and time Using Outlook 1
CWM550 Wrong Date Using Outlook 4
C Outlook 365 Copy/Save Emails in Folder Outside Outlook to Show Date Sender Recipient Subject in Header Using Outlook 0
R unable to filter tasks when start date is on or before today Using Outlook 3
S Combination Field (Date Format) Outlook VBA and Custom Forms 0

Similar threads

Back
Top