7 Replies Latest reply: Oct 11, 2017 7:42 AM by Christian Schmitz RSS

    Can't use max() function in script?

    Christian Schmitz

      Hi there,

       

      I am having some problems to use the max() function in the script, in the frontend it works.

       

      I am trying to find my maximu !m value of the field SCFI date. I have already formated a newly generated field which shows the dates numerical. But there is still an issue with calculating the maximum.

       

      max(SCFI_date_num) as SCFI_Max

       

      The script generator stops with the hint:"Invalid expression", which is totaly nonsense... why should the max() function does not work anymore?

       

      Any help really appreciated.

       

      Chris