1 Reply Latest reply on Mar 16, 2016 2:28 AM by Sai Kiran

    Merging Dates in Calculated Field

    Sunil Rai

      Dear all,

       

      Is there a way to combined dates in a calculated field easily. Right now my date is string (20160121) and what I need to do is to pull out sales data for specific weeks.

       

      So I will use the formula

       

      if date='20160116' OR '20160122' OR etc etc THEN Sales Qty END

       

      But I was wondering if it can be made easier if I change my string date to actual date using dateparse and then somehow put in the calculated field something like this (don't know if it is possible though).

       

      If date='20160110' to '20160118' then sales qty end.

       

      So instead of typing individual dates using the OR function, I can use a 'to' type function, if available, to combine time periods.

       

      Any help will be greatly appreciated.

       

      Cheers,

      Sunil