8 Replies Latest reply: Oct 24, 2013 5:44 AM by jagan mohan rao appala RSS

    Comparison date range selection

      Dear community,

       

      Attached herewith a document with little problem in date range selection.

       

      I can't activate the date selection from calendar, it is only working with list box selection (but list box is not desired).

       

      Root cause 1:
      Might because the variables (vStartDate,vEndDate,vComparisonStartDate and vComparisonEndDate) are in "num" format type, how do I set the variable in date type?

      Actually all variables are getting value from ShortCreatedDate while my ShortCreatedDate is already in date type as shown in script:

      Date(floor(ShortCreatedDateTime),'YYYY-MM-DD') as ShortCreatedDate

      I am not sure why it still shows "num" format...

       

      Root cause 2:

      All the variables are unable to activate the field correctly, I have set up both field event triggers and variable event triggers.

      Anyone can help to take a look?

       

       

      Thanks and best regards,

      Chanel