4 Replies Latest reply: Aug 30, 2012 8:13 AM by Shubham Kumar RSS

    From Date and To Date problem

    Shubham Kumar

      Hi, Have attached the code which I am using to get the from date and to date, but it's not working. Could you please look into it and let me know where I am going wrong. Best Regards,

        • Re: From Date and To Date problem
          Sree Nivas

          How you are differentiating from date and to date for both you are refering the same column and also in all the tables you are using same field name fromdate,todate it will create syn tables also.

          • Re: From Date and To Date problem
            jagan mohan rao appala

            Hi Subham,

             

            I noticed that there are From_date and to_date in multiple tables, which creates synthesis key.  Also how you are getting from and two date?

             

            Why you are arriving same fields for example (INQUIRY_RECEIVED_DATE) multiple times as two different fields?

             

            Generally in this situation, I will provide 2 date objects for selecting From and to and assign it to a variable.  By using set analysis I will filter the data based on the above selected From and to dates.

             

            =Sum({<Date={'>=$(=vFromDate)<=$(=vToDate)'}>} Sales)

             

            If possible I wil provide an example sooner.

             

            Regards,

            Jagan.