Hi @JayMoney,
Could you do the following to achieve your goal:
Under Doctor type, have a start clinic field (number) and end clinic filed (number), which would be the hours they start and end clinic.
When current date/time :extract hour > Doctor’s start time and when current date/time :extract hour < Doctor’s end time, then show something or do whatever you need to do to indicate the doctor is currently in clinic.
This way, it has nothing to do with the date. You can also include week day number into this to check what day of the week it is.
Keep in mind that hours are on a 24 hour thing, so 1pm’s hour would be 13, etc.
Gaby | Coaching Bubble