format of query export using M/d/yy h:mm a

If you think that something doesn't work in Aware IM post your message here
Post Reply
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

format of query export using M/d/yy h:mm a

Post by tford »

I have a query that uses M/d/yy h:mm a which properly displays on the screen as 5/13/07 5:34 PM. When I click on export, it opens up in Excel as 5/13/07 17:34. Looks like it is still carrying the 24 hour formatting.

Tom
aware_support
Posts: 7525
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Post by aware_support »

Thanks, we'll have a look.
Aware IM Support Team
Post Reply