TimeofDay Formatting
I have a TimeOfDay field using 24 hour clock to track incidents. I simply would like to identify any time entered between 00:00 to 10:00 = "Morning" Between 10:01 to 13:00 = "Mid-day" Between "1...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnot tested but try this
var TimeOfDay TOD = [My time of day field];
IF(
$TOD > ToTimeOfDay("12:01am") and $TOD <= ToTimeOfDay("1:00 pm"), "Morning"
$TOD > ToTimeOfDay("1:00 pm") and $TOD <= ToTimeOfDay("5:00 pm"), "Afternoon",
$TOD > ToTimeOfDay("5:00 pm") and $TOD <= ToTimeOfDay("12:00 am"), "Evening",
IsNull($TOD, "", "Other")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var TimeOfDay TOD = [My time of day field];
IF(
$TOD > ToTimeOfDay("12:01am") and $TOD <= ToTimeOfDay("1:00 pm"), "Morning"
$TOD > ToTimeOfDay("1:00 pm") and $TOD <= ToTimeOfDay("5:00 pm"), "Afternoon",
$TOD > ToTimeOfDay("5:00 pm") and $TOD <= ToTimeOfDay("12:00 am"), "Evening",
IsNull($TOD, "", "Other")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- A few syntax errors. but it worked! got me to where i can take it. Thanks!!
------------------------------
Rob Salaj
------------------------------
