TIME Value List - Does not show 12 am / Midnight
I have created a table called "Time Values" where each record represents a time in 15 minute intervals, I then created a value list of this table and selected the option "Include All Values".
Problem - Every time shows other than 12 AM
- The field on 'Time Values" is a time field, if switched to a text field the 12 AM shows up, but in an unwanted order ( 1 AM, 1 PM, 1:15 AM, 1:15 PM)
- putting the record to 24:00 works, but I need the value list displayed in 12 hour time.