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
    Commented Feb 6, 2023 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
  • 1
    Thanks for the details :)
    – Andrew15
    Commented Feb 6, 2023 at 16:04
  • Great, glad it worked for you. Please accept it as an answer as it helped you and it will help others with similar questions in future. Commented Feb 6, 2023 at 17:10

Your Answer

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

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