Results 1 to 4 of 4

Thread: Date Format(formatdatetime)

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2001
    Location
    Earth
    Posts
    762

    Cool Date Format(formatdatetime)

    hi All!!!!

    i want to custom data format thru

    formatdatetime

    but it's only have fixed formats..
    how i make format like this dd/mm/yy

    thanks

  2. #2
    Addicted Member
    Join Date
    Jul 2002
    Location
    Brussels, Belgium
    Posts
    139
    Create your own function using the Day(), Year() and month() functions

  3. #3

  4. #4
    Frenzied Member msimmons's Avatar
    Join Date
    Jul 2001
    Location
    Houston, TX
    Posts
    1,057
    here's an easier one that I wrote
    Code:
    datarr = split(VARdatmmddyy, "/", -1, 1)
    datddmmyy = datArr(1) & "/" & datArr(0) & "/" & datArr(2)
    hope that helps
    michael
    I'm off to GalahTech, hope to see you there.

    If you don't like the rules they make, refuse to play their game. -- Steve Ignorant.

Posting Permissions

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



Click Here to Expand Forum to Full Width