Help creating a "Time" value set
I am looking to create a LOV that populates with standard time, not military, in a time sequential order. It needs to be in 30 min increments from 12 AM to 1130 PM.
When I enter this:
12:00 AM
12:30 AM
01:00 AM
~
12:00 PM
12:30 PM
01:00 PM
It re-orders like this:
01:00 AM
01:00 PM
12:00 AM
12:00 PM
.....and so on.
Unfortunately, the users won't accept military time, so I need some guidance. Looking for some sort of simple tip/trick to get these in the proper order. Any pointers would be GREATLY appreciated!
Thanks,
Matt
When I enter this:
12:00 AM
12:30 AM
01:00 AM
~
12:00 PM
12:30 PM
01:00 PM
It re-orders like this:
01:00 AM
01:00 PM
12:00 AM
12:00 PM
.....and so on.
Unfortunately, the users won't accept military time, so I need some guidance. Looking for some sort of simple tip/trick to get these in the proper order. Any pointers would be GREATLY appreciated!
Thanks,
Matt
0