# Appointment SLOT

**URL:** https://forums.knack.com/t/appointment-slot/10094
**Category:** Get Answers
**Created:** [January 17, 2017, 3:46pm UTC](https://forums.knack.com/t/appointment-slot/10094 "2017-01-17T15:46:30Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![andrewstee38626](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)
#### Post date: [January 17, 2017, 3:46pm UTC](https://forums.knack.com/t/appointment-slot/10094/1 "2017-01-17T15:46:30Z")

</div>

Hi, does anyone have an idea as to how I could populate a field to say MORNING, AFTERNOON, EVENING based on the time of day recorded in a date field?

I cant find any FILTER or criteria that uses the time rather than the date ... any ideas would be gratefully received :)

thanks

Andrew Steele

UK Knack developer and user.

---

<div class="post-metadata">

### Author: ![andrewstee38626](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)
#### Post date: [January 22, 2017, 10:20pm UTC](https://forums.knack.com/t/appointment-slot/10094/2 "2017-01-22T22:20:14Z")

</div>

Hi Neal,

&nbsp;

yes it is a bit tricky but I will use 'AM' as a filter for MORNING appts, and then it makes it easier to sort out the AFTERNOON and EVENING ones. &nbsp;There are no crossover times then as they dont work after 7pm so i can use PM and 1,2,3,4 etc

I think it will work, but I will experiment this week.#

thanks for your help and interest.

Andrew.

---

<div class="post-metadata">

### Author: ![andrewstee38626](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)
#### Post date: [January 21, 2017, 11:04pm UTC](https://forums.knack.com/t/appointment-slot/10094/3 "2017-01-21T23:04:59Z")

</div>

wow, sussed it out ...&nbsp;

create a text eqaution based on the last 7 letters of the date/time field&nbsp;

right({Date/Time},7)

this gives an answer of 12:15am for example

then create a text field with conditional filters

if field contains a certain string then set field to 'Morning' etc - seems to work but needs a lot fo conditional filters - I will try to refine further.

&nbsp;

---

<div class="post-metadata">

### Author: ![andrewstee38626](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)
#### Post date: [January 21, 2017, 10:55pm UTC](https://forums.knack.com/t/appointment-slot/10094/4 "2017-01-21T22:55:30Z")

</div>

Hi Neal,

yes I cant find a way to isolate the time from a date/time field otherwise your method would work fine, and all the filters for the fields are based on date.

Ive tried a SLOT object, but the number of days and slots and people needing them means the record count would be enormous. &nbsp;4 slots per day x 5 days per week x 100 representatives.