Results 1 to 3 of 3

Thread: How do you change date / time with a string?

  1. May 21st, 2000, 11:36 PM #1
    IQM
    IQM is offline

    Thread Starter
    New Member
    Join Date
    Mar 2000
    Posts
    13
    I'm making a program that involves letting the user change the time manually. They enter the date or time in the textbox and press the command button. I can't get this to work because the DATE and TIME use the long format and the textbox uses strings. I get an error like
    "#9:00:00 PM#" (INVALID FORMAT) or something. I believe it is because of the quotes ("") due to the textbox strings. How do you convert long to string, or fix this problem? Thanks.
    Reply With Quote Reply With Quote
  2. May 22nd, 2000, 04:56 AM #2
    Phobic
    Phobic is offline
    Hyperactive Member
    Join Date
    Sep 1999
    Location
    Cleveland, Ohio
    Posts
    263
    Use the CDate function.
    Phobic
    Reply With Quote Reply With Quote
  3. May 23rd, 2000, 04:02 AM #3
    IQM
    IQM is offline

    Thread Starter
    New Member
    Join Date
    Mar 2000
    Posts
    13

    Thanks

    Thanks a lot. I really needed to know that.
    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