3 Replies Latest reply: Aug 11, 2017 7:09 AM by Retko Okter RSS

    max(Year)-1 returns somethins wrong date

    Retko Okter

      Hello,

      I have a listbox with years (including 2018 from calendar database) and a variable vPriorYear, which has assigned    =max(Year)-1.

      Now I created a text box with this - =$(vPriorYear) or I also tried this -   =vPriorYear .

       

      Now I click through the years ans sometimes ( cant predict when) instead of the last year of the clicked year itdisplays 2017. So for example I click 2014 and text box displays 2017. It only reverse to 2017 year, not other different year.

       

      I this behaviour familiar to someone? What can I do? Is here some other expression to refer to previous year of the selected that I can try?

       

      Thank you.