In my report I need to show the date and time of admission. There is one database field for this titled ch_adm_dt. I have this field on the report 2 times once as a date field and once as a time field. The date and time will result for each account the report pulls. I have created a formula field title Hour that I want to pupulate with a number for example if the admit time is between 0:00 and 0:59:59 then populate with a 1 for first hour and if it is 11:00 to 11:59 then populate with 12 for the twelth hour and if 23:00 to 23:59:59 then populate with 24 for the twentyfourth hour. How can I accomplish this?
Acct# Adm Dt Adm Tm Hour
111 3/1/15 0:03 1
222 3/5/15 11:21 12
333 3/6/15 23:59 24
IP Logged
