Results 1 to 2 of 2
  1. 06-17-2009, 03:36 PM #1
    TEN
    TEN is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2009
    Posts
    7

    Convert date format yyyymmdd for datediff

    Hi, everyone.
    I am trying to convert a numeric date formated yyyymmdd to a format that the DateDiff function will accept.



    any help is appreciated.
    Reply With Quote Reply With Quote
  2. 06-17-2009, 09:35 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I know you said it was a numeric date but is it a Text field or a LongInteger or what?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Convert date mm/dd/yyyy to January 1, 2009 format
    By Corinne in forum Access
    Replies: 1
    Last Post: 06-11-2009, 05:40 PM
  2. how to convert week number to date range
    By qwang1115 in forum Access
    Replies: 1
    Last Post: 02-13-2009, 11:35 AM
  3. Convert string to date
    By ~SwAmPdOnKeY~ in forum Queries
    Replies: 4
    Last Post: 09-11-2008, 07:19 PM
  4. Date Format
    By wasim_sono in forum Forms
    Replies: 2
    Last Post: 08-15-2006, 01:20 AM
  5. Date Format
    By St3ph3n in forum Access
    Replies: 4
    Last Post: 03-09-2006, 11:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums