1 Reply Latest reply on Aug 26, 2013 9:19 AM by Alex Kerin

    Custome date issue

    aamir.zamir.0

      I am creating custom date but i am getting some issue

       

      DATETIME(STR(DATEPART('month', [date_of_loss]))

      +  "/" + STR(DATEPART('day', [date_of_loss]))

      + "/" + STR(DATEPART('year', [date_of_loss]))

      +" "

      + STR(17)+ " :"

      + STR(0)+ " :"

      + STR(0))

       

      this give result  11/01/2013 12:00:17 AM

       

      I need this result 11/01/2013 05:00 PM

       

      can you please guide me ??

       

      Tracy Rodgers Alex Kerin Kelly Osterhout Gourav Kumar