New call-to-action
Results 1 to 4 of 4

Thread: Date search stopped working

  1. #1
    Member
    Real Name
    David
    Join Date
    Sep 2008
    Location
    Maryland, USA
    Posts
    11

    Exclamation Date search stopped working

    Using A5V9, SQL Server 2005.
    Date range search worked fine (mm/yy/dd) then stopped working.
    I've tried everything I can think of including new install of A5V9 with latest patch and SQL Server 2008 on another box. Same problem. Date picker works too. No records are returned. All other search fields work fine.
    Any suggestions?
    ~David

  2. #2
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,416

    Default Re: Date search stopped working

    I beleive sql standard for date is yyyy/mm//dd

    Chad

  3. #3
    Member
    Real Name
    David
    Join Date
    Sep 2008
    Location
    Maryland, USA
    Posts
    11

    Default Re: Date search stopped working

    Thanks Chad, but I've tried every date format I can think of.
    ~David

  4. #4
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: Date search stopped working

    David,
    I know just enough about SQL to be dangerous (probably even less than that!), but as I know that even QuickBooks utilizes more than one date format and is treated as a SQL connection when Alpha connects via the QODBC driver, I figured that your SQL may as well.

    I did a quick Google and this link may give you a few (over a dozen actually) formats you probably did not try.....hope it helps.

    http://ehockeycoach.net/devgenuity/A...meFormats.aspx
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




Similar Threads

  1. Search in grid stopped working - was .a5w page.
    By peteconway in forum Application Server Version 10 - Web/Browser Applications
    Replies: 4
    Last Post: 09-09-2009, 09:03 AM
  2. Form Stopped working
    By BOB SULLIVAN in forum Alpha Five Version 6
    Replies: 3
    Last Post: 10-30-2006, 09:36 PM
  3. Mail stopped working
    By Jonathan Earle in forum Alpha Five Version 6
    Replies: 2
    Last Post: 06-20-2005, 05:45 AM
  4. stopped working
    By Schulzie in forum Alpha Five Version 4
    Replies: 7
    Last Post: 01-14-2005, 06:23 AM
  5. POST stopped working
    By walhoney in forum Alpha Five Version 1
    Replies: 1
    Last Post: 08-16-2000, 05:44 AM

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
  •