7 Replies Latest reply: Sep 29, 2017 3:57 PM by Anand Chouhan RSS

    If Statement with AutoCalendar field

    Joseph Cater

      I am trying to show both year and month with the following statement:

      if(year([first_paymnt_date.autoCalendar.YearMonth])<=2014,'',year([first_paymnt_date.autoCalendar.YearMonth]))

       

      Any suggestions of how to combine year and moth?

       

      Thanks