RT Query question

To List,

Whenever I create a query and want to include the Requestor(s), I always
get the email address, ie. "KFCrocker@lbl.gov". What I want is the name
only, “KFCrocker”. In the “advanced” section, I see this code
"Requestors". What can I change that to to just get the requestors name?



To all,

I want to modify the way dates are displayed when I run a query,
especially since I want to download the info to a spreadsheet. I just
want the date, no time, no day-of-week, etc. I just want it to show
"dd/mm/yyyy". Is there some way to do this in advanced or some way to
select it differently? I hope someone has an answer cause this is a real
pain for me. Thanks.