Alpha Video Training
Results 1 to 7 of 7

Thread: Is date() tied to system settings

  1. #1
    Bo Vandenberg
    Guest

    Default Is date() tied to system settings

    Two win98 machines have refused dates entered in a form. The field rules are set to 'date()' and I have no problem on my development machine.

    On the machine I was able to inspect it accepted the date if it was mm/dd/yyyy when on my devel maching it is dd/mm/yyyy.

    Is this tied to local settings on the machine & can I isolate it so that it doesn't change???

    Any help appreciated.

    Bo

  2. #2
    Keith Regan
    Guest

    Default RE: Is date() tied to system settings

    Bo,
    yes it is via Regional and Language options. Date() returns in the format set there. So, if set to US English you will getr format mm/dd/yyyy, set to UK English and dd/mm/yyyy. Default setup wityh any windows system is US (now does that tell you something :-) ).

    HTH

    Keith

  3. #3
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,314

    Default RE: Is date() tied to system settings

    Bo,

    I think the date value is stored internally as

    YYYYMMDD

    but what you're seeing is a display setting, often the result of the user's personal regional settings in Windows itself.

    --tom

  4. #4
    Keith Regan
    Guest

    Default RE: Is date() tied to system settings

    Tom,
    I think you are right (as usual). For fun I used date_value() and added a bit to the days and months in the interactive window, date_value(2003,13,12) and it rolled the month and year over. Now I suppose the question is what use is this?

    Keith

  5. #5
    Bo Vandenberg
    Guest

    Default RE: Is date() tied to system settings

    Is there an entry mode I can use that I can predetermine for my application? Most users have no idea what the setting on their machine is. Can I make Alpha 5's date() do a conversion? it would be nice to exclude their system settings.

    This also makes it more difficult to share a machine with another database.

    Bo

  6. #6
    Keith Regan
    Guest

    Default RE: Is date() tied to system settings

    Bo,
    In the ref guide it gives a date_format(), looks like you can bring this in as any format you like. Give it a try, it may work for you.


    Keith

  7. #7
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,314

    Default RE: Is date() tied to system settings

    Bo,

    Windows thinks differently. In other contexts I've found it VERY difficult to build a Windows app that goes against the grain established by Microsoft.

    -- tom

Similar Threads

  1. System date field
    By Karen Moritz in forum Alpha Five Version 4
    Replies: 7
    Last Post: 07-28-2010, 01:20 PM
  2. Settings -> System -> Directories
    By Mike Konoff in forum Alpha Five Version 6
    Replies: 0
    Last Post: 02-26-2005, 05:56 PM
  3. System date on report header
    By fairviewcomputing in forum Alpha Five Version 5
    Replies: 13
    Last Post: 07-20-2004, 07:33 AM
  4. System clock settings - AM , PM
    By Ross Watkins in forum Alpha Four Version 6 and Prior
    Replies: 4
    Last Post: 07-11-2000, 10:00 PM
  5. system date
    By larry bradley in forum Alpha Five Version 4
    Replies: 8
    Last Post: 04-18-2000, 06:25 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
  •