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

    Issue with timestamp date format in Set analysis

    Anand kumar



      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



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


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


      Set expression:





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


      Kind Regards,