2 Replies Latest reply: Jun 6, 2013 3:10 AM by Haider Al-Seaidy RSS

    Timestamp Format

      Good morning QV addicts,

       

      I am trying to format a TimeStamp in the following way:

       

      YYYY-MM-DDThh:mm:ss (e.g. 1997-07-16T19:20:30)

       

      The issue I am seeing is that the 'T' which signifiies the start of the time component turns the timestamp into text which then means I cannot use MIN, MAX functions on the field. Can anyone advise me on the correct format code to achieve this and retain the field as numeric and not text?

       

      Thanks in advance

       

      Haider