excel querys

excel querys

Hi, 

I'm using MS Excel 2007 for reporting purposes, via ODBC driver to SDP MySQL Database, and i've a problem with dates, cause when i'm in msquery the query returns the data, but when i clic to return to excel it's not anymore. (the entire column dissapear)...

I'm usigng the lastest release of sdp.

As an example of how i get dates in my querys is:

(from_unixtime(wo.CREATEDTIME/1000, '%Y-%m-%d')

I hope someone can help!

Best regards,

jcaceresy

                  New to ADSelfService Plus?