Topic
  • 1 reply
  • Latest Post - ‏2013-08-01T21:21:33Z by RobertDickson
MolumaTresa
MolumaTresa
23 Posts

Pinned topic Rule logic to get the maximum of a date column in Information analyser

‏2013-08-01T06:10:07Z |

As in IA the function "Max" will only accept numeric value as the input parameter and will throw an error if if use

max(date_column) 

So how can I get the max(date_column) in IA as it is not permiting me to use the function max .

 

So can someone help me with the rule logic to find the max(date_colummn) as soon as possible 

  • RobertDickson
    RobertDickson
    105 Posts

    Re: Rule logic to get the maximum of a date column in Information analyser

    ‏2013-08-01T21:21:33Z  

    Hi,

    You can use the val function to convert strings to numbers.  Something like max(val(date_column)).  You might need to use substring to get the numeric parts of the date if it has - or /...

     

    Regards,

    Robert