Alpha Video Training
Results 1 to 5 of 5

Thread: UK/US date format problem using date picker

  1. #1
    Member Robert Rough's Avatar
    Real Name
    Robert Rough
    Join Date
    Sep 2004
    Location
    Hamilton, Scotland
    Posts
    307

    Default UK/US date format problem using date picker

    How do I overcome date formatting problem when using date selector.

    Problem
    See attached thumbnail.

    When I select dates using the date picker to display information in a grid the resultant date in the date window is US format mm/dd/yy and the values are selected correctly and in UK dd/mm/yy format.

    If I don't use the date picker and insert the values in UK format dd/mm/yy the grid returns no records found values found.(obviously because the value entered is not in US format)

    Not the ideal.
    Iam based in UK and the web server being used is UK based. All set to appropriate Uk international date formats.

    Can someone offer a solution.
    Thank You
    Robert

  2. #2
    "Certified" Alphaholic peteconway's Avatar
    Real Name
    Peter Conway
    Join Date
    Oct 2005
    Location
    Melbourne, Australia
    Posts
    2,537

    Default Re: UK/US date format problem using date picker

    In field properties for the search ensure the date picker is set to dd/mm/yyyy - it always defaults to mm/dd/yyyy.

  3. #3
    Member Robert Rough's Avatar
    Real Name
    Robert Rough
    Join Date
    Sep 2004
    Location
    Hamilton, Scotland
    Posts
    307

    Default Re: UK/US date format problem using date picker

    Hi Pete

    I did as you suggested and the picker now displays in the correct format but does not now pick up any values. It seems as if the dates are stored in American format "somewhere"???? I've checked the tables and all ok in Uk format.

    Thanks for your input
    Regards Robert

  4. #4
    "Certified" Alphaholic peteconway's Avatar
    Real Name
    Peter Conway
    Join Date
    Oct 2005
    Location
    Melbourne, Australia
    Posts
    2,537

    Default Re: UK/US date format problem using date picker

    If you work on this you will solve it. There is a way to trick the grid. In you display setting for the field (in the seatch part of the grid) change the control type to "Calander", set the date properties to dd/MM/yyyy, save the grid, now change the property to TextBox, scroll down to th date picker and confirm it is still dd/mm/yyyy, then save.

    Now goto the Properties of the Componet type for the grid, scroll to the bottom, you will see advanced, scroll down, check the box the says, Date format on server does not match client, now save -

    give it a go, good luck!

  5. #5
    Member Robert Rough's Avatar
    Real Name
    Robert Rough
    Join Date
    Sep 2004
    Location
    Hamilton, Scotland
    Posts
    307

    Default Re: UK/US date format problem using date picker

    I'll give it a go, Peter, and let you know how I get on. And i thought life was so simple.
    Regards Robert

Similar Threads

  1. Date Picker icon
    By vinyltap in forum Web Application Server v7
    Replies: 4
    Last Post: 11-30-2006, 09:41 AM
  2. Date format problem
    By cellboy in forum Alpha Five Version 7
    Replies: 1
    Last Post: 03-30-2006, 05:50 PM
  3. Turn Off Date Picker?
    By Rich Hartnett in forum Web Application Server v7
    Replies: 1
    Last Post: 12-03-2005, 02:41 AM
  4. Date Picker presets in WAS
    By René Stout in forum Archived Wishlist
    Replies: 2
    Last Post: 10-17-2005, 03:22 PM
  5. date picker behaviour
    By René Stout in forum Web Application Server v6
    Replies: 7
    Last Post: 09-26-2005, 03:55 PM

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
  •