SitePoint Sponsor

User Tag List

Page 2 of 2 FirstFirst 12
Results 26 to 27 of 27
  1. #26
    SitePoint Enthusiast
    Join Date
    Feb 2005
    Posts
    74
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    guess everyone has their pref...if a date then i believe it should be a date...you wouldn't put an int/number in a text field....although i see it works it seems a lil unorthodox

    BSL

  2. #27
    SitePoint Enthusiast afgmail's Avatar
    Join Date
    Jan 2005
    Location
    Houston, TX
    Posts
    88
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I always use this code:
    Code:
    Function JXIsoDate(dteDate)
    'Version 1.0
       If IsDate(dteDate) = True Then
          DIM dteDay, dteMonth, dteYear
          dteDay = Day(dteDate)
          dteMonth = Month(dteDate)
          dteYear   = Year(dteDate)
          JXIsoDate = dteYear & _
             "-" & Right(Cstr(dteMonth + 100),2) & _
             "-" & Right(Cstr(dteDay + 100),2)
       Else
          JXIsoDate = Null
       End If
    End Function
    Taken from this article: http://www.4guysfromrolla.com/webtec...022202-1.shtml
    Scan completed....
    Brain not found.
    filecabin.com : Notepad2


Bookmarks

Posting Permissions

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