Creating a new calculated field in a SharePoint List (Office 365) that combines a text (Region) and a date (StartDate) column. The Region field has a value "DFO" and the StartDate has a value of "8/3/2022", which the user selects from a calendar drop-down. The new field type is a "Calculated (calculation based on other columns)" type. However, the output doesn't show the date correctly, it looks like this "DFO_44776".

Any thoughts/suggestions? The calculated field code is:


2 Answers 2


Please try to use this formula:

=[Region]&"_"&TEXT([StartDate], "mm-dd-yyyy")
  • Thanks, worked great
    – Andrew15
    Feb 6 at 16:04

Use formula for your calculated column like this:



  1. Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,). For example: If you are using German language for your SharePoint site

Official Documentations:

  1. Calculated Field Formulas

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.