5 Replies Latest reply: Jun 29, 2017 11:37 AM by Sunny Talwar RSS

    Issue with timestamp date format in Set analysis

    Anand kumar barri

      Hi

       

      I have an issue with the date format in set expression ,

       

      The issue is

       

      I have a field which consists timestamp in the date field and I just wanted to compare only the date part with a variable inspite of doing it with the whole times stamp i.e from the below example I should use only 6/27/2017 should be compared with the Variable defined

       

      I was unable to find that out a proper solution for that ,so changed the variable to have a timestamp, but this case can go wrong if the timestamp in field has time other than 12:00:00 AM

       

      Field:

      ORDER_CLOSED_DATE = 6/27/2017 12:00:00 AM

      Variable:

      vCurntOrdrclsddate =Timestamp(Timestamp#(today(),'M/D/YYYY')-2,'M/D/YYYY hh:mm:ss TT')

       

      Set expression:

      if(Ord_Status='Cancelled/Withdrawn',count({<ORDER_CLOSED_DATE={'$(=vCurntOrdrclsddate)'}

        ,ORDER_PRODUCT={'Full','','-'}

        ,ORDER_STATUS={'CANCELLED','','-'}>}ORDER_NBR)

       

      Can somebody help me out in getting a resolution for this.

       

      Kind Regards,

      Anand.