Skip to Content
Former Member
Jul 07, 2016 at 08:01 PM

Need to consolidate 3 fields for group


I have a problem with using a database called Dentrix. This has a column patient appointment which is date time

however i see that the time part is not used. They are all 120000am. But there is 2 other fields, time-hour and time-minute that are used.

I need to sort the data by date time. So I need to sort of use the date part of datetime, and add in the other 2. How is this to be done?