http://dashboard.infocaptor.com/ Dashboard Discussion, Support, Examples, Help Topic: Number formatting SQL server dashboard en Sat, 11 Sep 2010 02:43:05 +0000 http://dashboard.infocaptor.com/topic/number-formatting-sql-server-dashboard#post-37 Tue, 30 Dec 2008 19:55:24 +0000 njethwa 37@http://dashboard.infocaptor.com/ <p>It seems that the Ship date is a numeric column and not a date datatype. InfoCaptor date column format is applicable to only date and time columns.</p> <p>Can you confirm what type of column is the ship Date? You could use the SQL server specific convert functions <a href="http://msdn.microsoft.com/en-us/library/ms187928.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms187928.aspx</a></p> <p>In your case, if Ship Date is a numeric column such as int then you could try the following for ship date</p> <p>select convert(datetime,convert(char(8),ship_date)) as shipping_date ...</p> <p>Once your SQL returns a datetime column, you could use InfoCaptor's date formatting. </p> http://dashboard.infocaptor.com/topic/number-formatting-sql-server-dashboard#post-36 Tue, 30 Dec 2008 19:35:19 +0000 guest 36@http://dashboard.infocaptor.com/ <p>Thanks for helping out….I got the $ numbers to display correctly, but as far as the dates being pulled from the SQL tables they are in YYYMMDD format. I have tried various settings but they do not affect the display. I am looking for MM-DD-YYYY. (don’t mind the 2030 Year…it is a scheduling thing.) </p>