2 Replies Latest reply on Nov 9, 2018 12:25 PM by maneesh.gaddam

    Date format/formula




      I have an audit trail date value like this "11/21/2014 9:38:21 PM" I have  formatted the date to be just the date part and not the time but I would also like a field for Time and then Id like to group the values by Before 6pm and after 6pm the problem I think will be that the date part will still be in there somehow. How do I break out the time piece to be independent of date? Im a relatively new user so just getting used to calcs etc.


      Help greatly appreciated, thanks