4 Replies Latest reply on Nov 27, 2018 10:32 PM by Sairam MVV

    Latest date by excluding milli seconds and seconds

    Sairam MVV

      Hi Guys,


      I have a column with update date, there i want to consider latest date data only.

      Below is example with some screen shots

      In above screen shot, we have update of 14/11/18 23.30 as 2 records as there is difference at milli seconds.


      Now i need the result by excluding seconds and milli seconds.

      Desired output should be

                                   Jan 18

      14-11-18 23:30   1790


      Thanks and Regards,