AnsweredAssumed Answered

TIME Value List - Does not show 12 am / Midnight

Question asked by JonathonKlassen on Oct 27, 2014
Latest reply on Oct 27, 2014 by JonathonKlassen

Title

TIME Value List - Does not show 12 am / Midnight

Post

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

Notes;

- 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.

 

Please Help..

Outcomes