3 Replies Latest reply: Mar 22, 2017 3:56 AM by Sunny Talwar RSS

    Picking specific data for the given year

      Hi, I am trying to load a data from a table which has few columns with one column as a year. When i use the following function it works



      but when I use  the following function it returns nothing.




      ValidForYear is the column with year and DeliveryDate is the Calendar date.

      I need to get the value from "NetMaximumCapacity" for the year selected by user based on data in other tables where "DeliveryDate" is used as date and time field.