7 Replies Latest reply: Nov 17, 2011 12:00 AM by Kamal Naithani RSS

    Earliest Date question

      Hi,

      How can I find out the earliest date in the data?

      I have a date field which I converted in mm/dd/yyyy format in the load script. This date represents when a ticket was created. How can I find out in my expression which is the earliest date a ticket was created. Is there a function like max(Date) which I know is used to find the latest date, but I want to go the other extreme (i.e. the earliest date).

      So, if the date field is CreatedDate, is there a function like min(CreatedDate) or any other workaround for this scenario.

       

      Thanks for your help.

      AM