Problem with Dates in Popup

Question

The Date/time shown in my popus is not the same as the database it is coming from. the popup shows 11/30/2011 11:07 while the database has 30/11/2011 00:37:02 Very Strange i think it is being converted to Universal time/ Greenich mean time (UT\GMT) this is very problematic as it means that our website shows lightning that will happen in the future!!! any ideas?? here is a section of the the popup xml i have attached pics of popup and database showing time and the id field {TIME_}
ID: {id}
Lat: {latitude}
Longitude: {longitude}
with an intensity of {amplitude} ]]> database.png popup.png

RichardDiaz · Answer

Thanks 
just ended up using a utc field for the popup data and an est (eastern standard time) for the labels, the pop gets converted to est on way through to web app 
very odd but it works now

Are you by any chance consuming data from Vaisala?

Regards,

Rick

Anonymous User · Answer

Original User: Hay

Thanks 
 just ended up using a utc field for the popup data and an est (eastern standard time) for the labels, the pop gets converted to est on way through to web app 
very odd but it works now

RobertScheitlin__GISP · Answer

A Hay,

Try:<format dateformat="shortDateShortTime24" useutc="true"/>