Results 1 to 4 of 4

Serious date formating problem when retrieving with database

Threaded View

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    italy
    MS-Off Ver
    Excel 2010
    Posts
    4

    Serious date formating problem when retrieving with database

    Hi all,

    I retrieved a data from Database and I have DATE field. Excel retrieved it as STRING, even if I'm changing the formatting to date it doesn't change!
    the only solution I have found is to use DATEVALUE function or simply do +0 to the field, both of these are not good for me. I must excel to understand it with formatting.

    my main need is to use MIN function. for now i get 0 because it STRING.

    excel problem.jpg

    Thanks!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1