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?