I have been struggling with converting my "start_time" field that is stored as text to a time format of "hh:nn" in my query.
In my query I put the following expression to try and convert from text to time value, but when I do the query reflects 00:00 for all records.
Expression: start_time2: Format(CDate([start_time]*1),"hh:nn")
I attempted to change the field to a number by multiplying the field by 1.
In my query I put the following expression to try and convert from text to time value, but when I do the query reflects 00:00 for all records.
Expression: start_time2: Format(CDate([start_time]*1),"hh:nn")
I attempted to change the field to a number by multiplying the field by 1.