J
Jacqueline
In working at a college we must pull our data from the state data management
system. I need to convert the class start time field into a true time stamp
in order to sort it correctly.
example of how the data comes to us: 0400P = 4:00 pm start time. Is there a
way to format this field at a true time within my query? I need to sort in
order of earlies time to latest time. The query runs a report that will go to
our scheduling assistants to determin if a room is available for a class.
Thanks
Jacqueline
system. I need to convert the class start time field into a true time stamp
in order to sort it correctly.
example of how the data comes to us: 0400P = 4:00 pm start time. Is there a
way to format this field at a true time within my query? I need to sort in
order of earlies time to latest time. The query runs a report that will go to
our scheduling assistants to determin if a room is available for a class.
Thanks
Jacqueline