Hey guys, I am using this query formula to order the responses from a form in descending order: =query(OfficerCheckForm1!A:H , "select * order by A desc", 1))
One of my form questions asks for a certain date,the issue i am having, is that the dates from the question arent being place in a d/m/y format, theyre being placed in a d/m/y H:M format. Is there anyways to stop it from adding military time at the end of each date?
And no, the original response sheet does NOT place it with military time. Only the query formula does this!
One of my form questions asks for a certain date,the issue i am having, is that the dates from the question arent being place in a d/m/y format, theyre being placed in a d/m/y H:M format. Is there anyways to stop it from adding military time at the end of each date?
And no, the original response sheet does NOT place it with military time. Only the query formula does this!