Peter van Mil
15-Jan-2014, 12:24 PM
I am very happy with the improved support of SQL datatypes in the Studio. I have been testing with time fields and found something strange. I have set the Form_Datatype to Mask_Time and the Form_Mask to "hh:mm". When I enter "08:15" the time is converted to "20:15" after the save. In the database it still is "08:15:00".
Times, that are "00:00:00" in the database are shown as "12:00". If I remove the Form_Mask, the time is displayed correctly.
So there seems to be something wrong with the Form_Mask (and European times).
Set Form_Datatype to Mask_Time
Set Form_Mask to "hh:mm"
7279
Times, that are "00:00:00" in the database are shown as "12:00". If I remove the Form_Mask, the time is displayed correctly.
So there seems to be something wrong with the Form_Mask (and European times).
Set Form_Datatype to Mask_Time
Set Form_Mask to "hh:mm"
7279