I have this calculated field:
IF [SampleCompleted] = TRUE
'Glucose: ' + LEFT(STR([Glucose]),4) + '
' +'Ethanol: ' + LEFT(STR([Ethanol]),4)
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?
You may have to pull out the components separately, hours, mins, etc and build it back up into a string of your design.
i.e. STR(DATEPART('hour',[PreTimeStamp])) + ':' + STR(DATEPART('minute',[PreTimeStamp]))