Concatenate with a Date

Sherry Fox

I am sure the answer to this is simple, but I just cannot get it. Here is my current formula:

=[TO - Project]@row + " - " + [Deliverable Number]@row + " - " + OY@row + " - " + [Date Submitted]@row

Now the Date Submitted field displays as MM/DD/YY, however I need it to display as MM-DD-YY

I have tried a few things, but all failed and resulted in the Unparsable error. Any help is appreciated.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You would copy what I provided and paste it where you currently have [Date Submitted]@row. My formula goes in place of that cell reference.

All comments

Paul Newcome

In place of [Date Submitted]@row, try this:

RIGHT("0" + MONTH([Date Submitted]@row), 2) + "-" + RIGHT("0" + DAY([Date Submitted]@row), 2) + "-" + RIGHT(YEAR([Date Submitted]@row), 2)

Sherry Fox

But how do I get that big formula added into my existing formula???

Paul Newcome

You would copy what I provided and paste it where you currently have [Date Submitted]@row. My formula goes in place of that cell reference.

Sherry Fox

@Paul Newcome ,

A little slow today, only 1 sip of coffee! LOL I got it, and thanks so much!!!!!!

Paul Newcome

Haha. No worries. Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.