Displaying Date Value In Formula

Post number 5 has been selected as the best answer.

Status
Not open for further replies.

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])
 
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

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.
 
Yes, try combination.

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
 
Status
Not open for further replies.
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
CWM330 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