Get date number in MMYY format only in Sharepoint designer 2013 RRS feed

  • Question

  • Hi,

    I have a column which already return with approved dates, which now I need to add another hidden column for MMYY. This column will be use for lookup later for Unique ID generator sort of.


    Existing column [Approved Date]=22/11/2016

    New required column [MMYY]=1116

    May I know, if i should use calculated column or single text(by adding formula some simple formula to lookup from [Approved Date])

    Can't find the suitable formula for results that I need.

    Much appreciate for answers.

    Thank you.

    • Edited by sund4y Tuesday, December 6, 2016 8:38 AM
    Tuesday, December 6, 2016 8:34 AM