Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Tricky - MAX Date Calculated Column

HI Experts I need to work out the latest ACT Date date Based on ID and NUM columns - the ACTDAte column must have dates against ALL ID and ALL NUM in order to get the MAX date.   As shown in our e...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    3 years ago

    Anonymous - You are going to have to come up with solution for the error that will come from variant data-type:

    Possibly just use -1 like:

     

     

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Anonymous - You are going to have to come up with solution for the error that will come from variant data-type:

Possibly just use -1 like:

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks Chris - Currently testing