New to the forum and hoping someone can help me. I've built a report that I can Group by Employee Name, Employee Schedule or the Schedule Start Time.
My problem is that the formula editor won't allow both string and date fields, so I had to convert the date field to a text field (using ToText), but now the report doesn't sort by time (as it now doesn't recognize that 1:00pm should come after 12:59pm. My formula is below, can anyone offer help?
if {?SortOrder} = "C"
then {Employee.Entity_Name}
else if {?SortOrder} = "A"
then {EmployeeSchedule.barName}
else if {?SortOrder} = "T"
then ToText ({EmployeeSchedule.fromDateTime})