Forum Discussion

browna6's avatar
browna6
Frequent Visitor
3 years ago
Solved

Creating a new reference column via a flat file (Date field)

Hi   I'm looking for some help with the below data. I want to create a new reference column - which is taking the date in the 'due date' column in the attached   For example if the due date is 30...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi browna6 

    try to add a calculated column like:

    Column = YEAR([due-date])*12+MONTH([due-date])

    it worked like:

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi browna6 

try to add a calculated column like:

Column = YEAR([due-date])*12+MONTH([due-date])

it worked like: