I want only time to show up in Date/time field

[panoss]

I have a date/time field. Format=Short time.
I want only time (hours:minutes) to appear.
But when I click in the text box, the full date appears.
I don't want this.


Is there a way to fix it?

[burrina]

You need to add format criteria for it to display correctly. Try this under your format setting.

hh:nn

[Missinglinq]

That's not going to work; it'll still show as Date and Time when the Control has focus. How, exactly, are you populating this Control?

Linq ;0)>

[burrina]

Depends on the control's data source and format used. If control is not enabled or if the table/field data type is set to medium time. Would need more details, but as posted it would work.

[panoss]

I converted the field to text (from Date/Time) and put a mask: 00:00\-00:00;0;_ (it's for working hours, e.g 09:00-17:00).
I guess what I needed was a mask and not a format, it works fine.

[June7]

A mask will work with Date/Time field as well but not if you want both begin and end times in the same field. How do you expect to calculate elapsed time?

[panoss]

I 'm not going to calculate elapsed time, it's just the working hours of shops.
There will be no calculation based on the working hours.
But...maybe it's a good thought to replace it with two fields of Date/Time type.
I 'll have to think a little more on this.