DateTime woes
Hi -
DF 20.0.7. MS SQL Express, DAW driver
I am saving records in a little table - well record size is little. The DateTime is set in the DD class and all records are saved by the exact same code & not updated after saving.
Code:
Procedure Field_Defaults
Forward Send Field_Defaults
Set Field_Changed_Value Field HLDCalibrationProbeDataPoints.DataPointDateTime to (CurrentDateTime())
End_Procedure
However, We get this:
The time portion switches (seemingly at random) between 12 & 24 hour format.
When you are attempting to get the last 5 records by the datetime & average them, the above doesn't cut it. Yes, I can hack it & use ID, but why would it do this?
Garret
Time for an oldie but goodie:
"If it ain't broke, you're not trying." - Red Green