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.
.i.e.
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.