Sharepoint Calculated Date

Posted on 2012-08-14
Last Modified: 2012-08-14
How to convert date column date dd/mm/yyyy to month format of yyyymm?
Question by:ALBERB01
    LVL 26

    Accepted Solution

    Create a new calculated column for your list (single line of text).
    Use the following formula to calculate its value
    =TEXT(NameOfYourColumn,"yyyy mm")

    Open in new window

    LVL 44

    Assisted Solution

    by:Rainer Jeschor
    which SharePoint version?
    Must the return column be a date format?
    You can use a calculated column of return type "Single line of text" with the following formula:
    =TEXT([Base Date],"yyyymm")

    Open in new window


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
    This collection of functions covers all the normal rounding methods of just about any numeric value.
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now