Dashboard Discussion, Support, Examples, Help » How-To

Number formatting SQL server dashboard

(2 posts)

  1. guest
    Member

    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.)

    Posted 1 year ago #

  2. njethwa
    Member

    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.

    Can you confirm what type of column is the ship Date? You could use the SQL server specific convert functions http://msdn.microsoft.com/en-us/library/ms187928.aspx

    In your case, if Ship Date is a numeric column such as int then you could try the following for ship date

    select convert(datetime,convert(char(8),ship_date)) as shipping_date ...

    Once your SQL returns a datetime column, you could use InfoCaptor's date formatting.

    Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.