time without seconds in group by

Applications Grid / Reports
#1

Hi There,

i use a group by and in the label i use a lookup that finds the name, and time (ev_name) and (ev_time} from another table to show the group by title in concat

the {ev_time} is showing also the seconds and i want to show only the hours and minutes but i can’t figure out how to do this.

#2

Yeah buy in this situation that didn’t work because the time is part of An lookup

#3

the you have to use a JOIN between the tables and use the date_format in your concat
DATE_FORMAT(ev_time, “%k:%i”)

#4

i’ll give it a try