I want to create a calculated field to extract the hour and minute field from a date field and then designate whether or not it is Day or Night shift.
Date = 3/30/2015 11:56 AM
The HH:MM would be 11:56.
If the MM/DD/YYYY HH:MM is between 3/30/2015 7:00 and 3/30/2015 19:15 it is Day Shift.
Date = 3/23/2015 11:56 PM
The HH:MM would be 21:56.
If the MM/DD/YYYY HH:MM is between 3/23/2015 19:00 and 3/24/2015 07:15 it is Night Shift.
What is the syntax to make this comparison?