Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007

    date/time field

    Hi folks.

    Does it not really matter if a date in Access is defined as 'text' in the data type column, rather than date/time.

    Because this way, I can get ColdFusion to output a list of members held in the database from a certain year, with just the date and not the time and in the correct format of dd/mm/yyyy rather than yyyy/mm/dd, which is what I was getting whn I set joinDate to date/time.

    Is it OK that I've used the text format rather than date/time, or will this produce errors somewhere along the line?

    Cheers, James

  2. #2
    acehowell is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Apr 2007


    This might create a problem down the line, but if it does just go and change it back and it will fix it, if you are not having problems now then use it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Date and time serch
    By gayano in forum Programming
    Replies: 1
    Last Post: 08-31-2007, 03:49 AM
  2. Microsoft Date and Time Picker 6.0
    By That Crazy Hockey Dood in forum Forms
    Replies: 0
    Last Post: 07-25-2007, 03:22 PM
  3. Time and date serch
    By gayano in forum Access
    Replies: 0
    Last Post: 07-05-2007, 07:59 PM
  4. Access Date/Time....I need a "generic" date.
    By beastmaster in forum Access
    Replies: 2
    Last Post: 12-29-2005, 12:55 PM
  5. date/time number
    By playfuljade in forum Forms
    Replies: 4
    Last Post: 12-19-2005, 12:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums