Results 1 to 3 of 3

Thread: Date Conversion to text format

  1. Apr 4th, 2003, 05:44 AM #1
    conquerer
    conquerer is offline

    Thread Starter
    New Member
    Join Date
    Apr 2002
    Location
    Cochin, India
    Posts
    9

    Date Conversion to text format

    hi guys,

    i have met with a prooooblem!!! if u ask me wot, i have a date to be prnited in Transfer Certificate (TC) of an Engg. College. the date if enterd in dd/mm/yyyy format , its to be transferred into text format. ie if the date is 03/10/2002 it's to be converted as third October twothousnd two. can ne one help me?? got ne function?? do help me plsssssssssssssssssssssssss.
    thanx..
    Reply With Quote Reply With Quote
  2. Apr 4th, 2003, 07:38 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343
    Use an array or look up table for the numbers 1-31
    As to the 2k parts hmmm well god luck.
    I'f go for converting to string ("2002") and then checking the first 1 or 2 digits and use a look up on that.


    Vince

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  3. Apr 4th, 2003, 07:46 AM #3
    kctrash
    kctrash is offline
    Member
    Join Date
    Jul 2002
    Location
    Belton,MO
    Posts
    37

    Trry this

    Temp = Datevalue( What ever the Field is )
    whops never Mind
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width