1 Reply Latest reply on Nov 22, 2016 6:52 AM by Andrew Watson

    Date converted to string in calculated field doesn't keep its default format.

    L L

      I have this calculated field:

       

      IF [SampleCompleted] = TRUE

      THEN

      ''+

      'Glucose: ' + LEFT(STR([Glucose]),4) + '

      ' +'Ethanol: ' + LEFT(STR([Ethanol]),4)

      ELSE STR([PreTimeStamp])

      END

      +CHAR(10)

       

      when STR([PreTimeStamp]) is display it is in 12 hour format when the default property is 24 hour format. I have tried DATEPARSE but its says it is a unknown function. Does anyone know how to make this date 24 hour when converting it to a string?