Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    3

    Unanswered: error of date type field in SQL server 2000 & mshflexgrid

    Hi
    this is my problem.
    mshflexgrid converts date value from dd.mm.yyyy to yyyy-mm-dd or mm.dd.yyyy

    When i use JetOLEDB & .mdb file
    I can show correctly date type field in mshflexgrid with str() function.
    For example

    rst.open"Select str(MyDateField) from table
    set mshflexgrid.datasource = rst

    i can see dd.mm.yyyy ' namely good
    when i dont use str() function i see mm.dd.yyyy ' bad version

    Now, i'm using SQL server 2000 & mdf file.
    mshflexgrid don't show correctly date field ( i want it to be like dd.mm.yyyy ) because i cant use str() function with SQL sever 2000 & mdf file

    For example
    rst.open"Select str(MyDateField) from table... occur error
    When i want to use Convert function in SQL server 2000 & mdf file
    it automaticly converts it like Jun 18 2004 12:00AM but i dont want this

    I want see this 18.06.2004 in Mshflexgrid.
    What can i do. help me pls.

  2. #2
    Join Date
    Mar 2005
    Location
    Netherlands
    Posts
    280
    Why convert to a string? Why not load it in mshflexgrid as a date and put a mask on it or something?

    But if you insist, search for "CAST and CONVERT" in the BOL and look up the use for the optional third parameter of the CONVERT function.

Posting Permissions

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