🚀 Salesforce Flow Date Formatting: 5 Easy Ways to Format Dates as Text
When building a Salesforce Flow, you may eventually need to take a Date value and place it inside a Text field.
For example, you might want to include an Opportunity’s Close Date in its Opportunity Name. The problem is that simply inserting a Salesforce Date value into a text formula may not produce the clean, readable format you expect. 😕
That’s where Salesforce Flow Date Formatting becomes important.
By using a Salesforce Flow formula, you can transform the individual parts of a Date—month, day, and year—into text and combine them into a consistent date format.
In this tutorial, you’ll learn how to format a Salesforce Date into Text in Flow, fix an incorrectly formatted Opportunity Name, and use a simple formula that you can copy and adapt to your own Salesforce Flow. ⚡
Table of Contents
Why Salesforce Flow Date Formatting Matters
Salesforce stores Date values as dates, but
sometimes you need that information to appear as part of a
text string.
For example, imagine your users want Salesforce to automatically
create an Opportunity Name using:
Account Name - Service Opportunity - Close Date
However, if you simply add the Date resource to your formula, the resulting value may not look the way you intended.
This is where Salesforce Flow Date Formatting becomes useful. You can convert the Date into individual text components and then combine those components into a clean and consistent text value.
This shows an Opportunity Name with the Close Date displayed in an unformatted, awkward way.
The Salesforce Flow Example
In this example, a button launches a Flow called
New Service Opportunity.
The Opportunity object has multiple Record Types, but users
frequently need to create Service Opportunities.
The Flow makes this process faster by allowing users to quickly
create a new Service Opportunity.
Include the Opportunity Close Date directly in the automatically generated Opportunity Name.
What Happens When You Don't Format the Date?
Initially, the Close Date is added directly to the Opportunity naming formula. The formula combines the Account Name, Service Opportunity, and Opportunity Close Date.
However, the resulting Opportunity Name doesn't display the date in the desired format. This happens because Salesforce is working with the value as a Date, while the Opportunity Name is a Text field.
The Flow needs to transform the Date value into text before combining it with the rest of the Opportunity Name. This is where Salesforce Flow Date Formatting solves the problem.
Finding the Opportunity Naming Formula in Flow
To fix the issue, open the Salesforce Flow and locate the element responsible for updating the Opportunity. In this example, the Update Opportunity element updates the Opportunity Name using a formula.
The important part to identify is the Date resource being inserted into the text formula.
How Salesforce Flow Date Formatting Converts a Date Into Text
Salesforce Flow allows you to use a formula to extract individual parts of a Date and convert them into text. Instead of inserting the Date directly into your text formula, we can break it into three simple components: Month, Day, and Year.
TEXT
(
MONTH
(
{Date}
))
+ "/" +
TEXT
(
DAY
(
{Date}
))
+ "/" +
TEXT
(
YEAR
(
{Date}
))
If you're formatting an Opportunity Close Date, replace {Date} with the applicable Close Date resource from your Salesforce Flow.
Breaking Down the Salesforce Flow Date Formatting Formula
Let's look at what each part of the formula does. The Date is broken into three separate values — Month, Day, and Year — before the final text value is created.
August 25, 2026 → {Date}
↓
8 → "8"
↓
25 → "25"
↓
2026 → "2026"
↓
8/25/2026
TEXT(MONTH({Date})) + "/" + TEXT(DAY({Date})) + "/" + TEXT(YEAR({Date}))
August 25, 2026 → 8/25/2026
Salesforce Date Formatter
Convert a Salesforce Date into readable text.
TEXT(MONTH({Date})) + "/" + TEXT(DAY({Date})) + "/" + TEXT(YEAR({Date}))
Updating the Salesforce Flow
Once you've created the new formula, return to the Flow and update the Opportunity Name formula. Replace the original Date resource with your new formatted Date expression.
Open the Flow and locate the formula that creates the Opportunity Name.
Account Name +
Service Opportunity +
Close Date
Remove the original Date resource and replace it with the formatted Date expression you created.
Account Name +
Service Opportunity +
Formatted Date
Save your changes and test the Flow to confirm that the Opportunity Name displays the Date in the expected format.
08/25/2026
✓ Ready
The formatted Date is now part of the Opportunity Name, giving users a consistent and readable naming format.
Activate the Updated Flow
After updating the formula, save your changes and activate the Flow. This ensures Salesforce uses the updated version when users create a new Service Opportunity.
If you test the Opportunity creation process without activating the updated version, Salesforce may continue using the previous version of the Flow.
Save your changes and activate the updated New Service Opportunity Flow.
Open the Opportunities tab, launch the New Service Opportunity Flow, and enter the required information.
Open the newly created Opportunity and review the Opportunity Name.
- ✓ Open the Opportunities tab.
- ✓ Start the New Service Opportunity Flow.
- ✓ Enter the required information.
- ✓ Click Next.
- ✓ Open the newly created Opportunity.
- ✓ Review the Opportunity Name.
Review the New Formatted Opportunity Date
After the updated Flow runs successfully, the Opportunity Name should now display the Close Date as a clean text value.
The Date is being added directly to the text formula, which can result in an unexpected or difficult-to-read representation.
The Date has been converted into text and can now be combined cleanly with the rest of the Opportunity Name.
The Close Date now appears in a consistent, readable format, making the Opportunity easier for users to identify.
Why Convert a Salesforce Date Into Text?
You might wonder why you would need to convert a Date into Text in the first place. The answer is simple: sometimes you need a Date value to become part of a larger text string.
Creating Record Names
Creating Text Summaries
Migration & Integration Values
Formatted Descriptions
Automated Naming Conventions
Salesforce Flow Date Formatting Formula
Here's the formula from the tutorial. Click any part of the formula below to see what it does.
Select any highlighted section above to learn what that part of the formula does.
Replace {Date} with the applicable
Date resource from your Salesforce Flow.
In this tutorial, that resource is the Opportunity
Close Date.
Build Your Date Formatting Formula
Instead of inserting a Salesforce Date directly into a text formula, you can break it into its Month, Day, and Year components and convert each component into text.
🎯 Final Thoughts
Salesforce Flow Date Formatting is a simple but useful technique when you need to include a Salesforce Date inside a text value.
Instead of inserting a Date directly into a text formula, you can use MONTH(), DAY(), YEAR(), and TEXT() to transform the individual Date components into text.
The result is a cleaner and more predictable value that can be used in Opportunity Names, descriptions, naming conventions, and other automated Salesforce processes. ⚡
TEXT(MONTH({Date})) + "/" + TEXT(DAY({Date})) + "/" + TEXT(YEAR({Date}))
Save this formula somewhere handy if you regularly build Salesforce Flows. Replace {Date} with the applicable Date resource whenever you need to convert a Salesforce Date into a readable text value.
❓ Frequently Asked Questions About Salesforce Flow Date Formatting
Find quick answers to common questions about formatting Salesforce Date values, using Flow formulas, and adding formatted dates to text values.
This is useful when a Date needs to be included in a Text field or combined with other text values.
When you need to combine a Date with other text, you may need to explicitly convert the Date components into text so Salesforce can use them within the larger text formula.
For example, a date in August returns:
For example:
For example:
Simply replace {Date} with the applicable Date field or Flow resource.
For example, you could structure the formula differently depending on whether you want:
Ready to Master Salesforce Flow?
Want to learn more about Salesforce Flow, formulas, data automation, and real-world Salesforce workflows? Explore more practical Salesforce training with Salesforce Masterclass.
Do You Know When to Convert a Date Into Text?
Test your understanding of Salesforce Date formatting and see when converting a Date into Text can make your Flow more useful.
Why might you convert a Salesforce Date into Text?
Challenge Complete!
One Response