Z
ZRexRider
Hi,
I have a date/time field in my SQL database. I want to display only
the time portion HH:MM. I had this working by doing the following:
If IsNull(objDateField.Value) Or objDateField.Value = "" Then
objTimeField.Value = ""
Else
objTimeField.Value = Format(objDateField, "hh:nn")
End If
This worked just fine until I realized that the above action makes
me.dirty=true and I lose the ability to detect True user edits to the
form when closing.
I would like to simply format the display of this value so that it
shows only the time portion.
My input mask for these time fields is: 00:00;0;_
However without my code above this field displays "11/12/2005 1:23:00
AM" even with this mask.
Is there a way to display this date as "01:23" without changing the
value (like my code is doing above)?
Thanks
I have a date/time field in my SQL database. I want to display only
the time portion HH:MM. I had this working by doing the following:
If IsNull(objDateField.Value) Or objDateField.Value = "" Then
objTimeField.Value = ""
Else
objTimeField.Value = Format(objDateField, "hh:nn")
End If
This worked just fine until I realized that the above action makes
me.dirty=true and I lose the ability to detect True user edits to the
form when closing.
I would like to simply format the display of this value so that it
shows only the time portion.
My input mask for these time fields is: 00:00;0;_
However without my code above this field displays "11/12/2005 1:23:00
AM" even with this mask.
Is there a way to display this date as "01:23" without changing the
value (like my code is doing above)?
Thanks