#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Jun 2004
    Posts
    8
    Rep Power
    0

    Angry Formating local date problem,


    Hi helpers,
    I need to have a specialized field for my voucher's local date which is totaly based on different calendar and formats with the system's. (English)
    So I created a feild in my table, as text data, and gave it a YYYY/MM/DD input mask in forms, but this field in many places like combo boxes, and reports controls is shown as a number, such as 31940. pls note that there is no similar calendar format in Windows system for my purpose.
    How can I avoid this, I mean I need this text (my local calendar date) to be shown as it is and entered. I dont need this feild for calculations, so text is appropriate.
    thanks in advance.
  2. #2
  3. No Profile Picture
    Contributing User
    ASP Discoverer (100 - 499 posts)

    Join Date
    Nov 2004
    Location
    The Netherlands
    Posts
    132
    Rep Power
    15
    I think like this:

    Go to your table (design view). set the Date field to Data Type "Date/Time" and set the input mask. Choose edit list in the input mask wizard box.

    Input mask: "9999/99/99"
    Mask Type: "Date-Time"

    Use the Sample data field to see if this is what you want.

    Should work.

    Thomas

Similar Threads

  1. A form w. critera for a query/ODBC Call Failed
    By OrangePunter in forum Microsoft Access Help
    Replies: 6
    Last Post: October 26th, 2004, 03:33 PM
  2. Javascript Date Validation
    By pegaafifm in forum HTML, JavaScript And CSS Help
    Replies: 0
    Last Post: September 4th, 2004, 11:34 AM
  3. Date Formating
    By evansc in forum Microsoft Access Help
    Replies: 2
    Last Post: August 5th, 2004, 10:35 AM
  4. Problem with date formats
    By Matt71 in forum Microsoft SQL Server
    Replies: 2
    Last Post: June 24th, 2004, 02:51 AM
  5. asp.net globalization date problem
    By DidMyTime in forum .NET Development
    Replies: 3
    Last Post: January 25th, 2004, 06:12 AM

IMN logo majestic logo threadwatch logo seochat tools logo