Time Field as EnumList reference to another Table is always returning 24 hours format

Friends,

I need a help…

  1. I have two tables 1) TimeSlots 2) Schedule.
  2. TimeSlots table is having a Slot column as Time (Ex: 5:00 AM, 6:00 AM)
  3. Schedule table is having a Available Slots column as a EnumList(Base type as Time) with Ref to TimeSlots[Slot].
  4. During Add / Update to Schedule table, Available Slots shows all the TimeSlots[Slot] as 24 hours format(05:00:00, 06:00:00) along with seconds. But i want them to appear as 12 Hours format(5:00 AM, 6:00 AM) with no Seconds. Is it possible? Please help me

3X_8_8_88a2bfd3236cc8e7c3f487c91ab2d6fe1ea88690.png

0 1 190
1 REPLY 1
Top Labels in this Space