Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Blue Springs, Missouri, USA
    Posts
    108
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Getting a File Created Date (XL 97)

    I can get the date and time a file is created or modified by using this code...

    FileDate = FileDateTime ("Filename")

    But I really just want the date... not the time... is there code that will do that for me?

    TIA

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Getting a File Created Date (XL 97)

    Try <pre>FileDate = Format(FileDateTime ("Filename"), "dd/mm/yy")</pre>

    substituting "dd/mm/yy" with your preferred date format.

    Andrew C

  3. #3
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Blue Springs, Missouri, USA
    Posts
    108
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Getting a File Created Date (XL 97)

    Works GREAT!!! Thanks Andrew

Posting Permissions

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