Results 1 to 4 of 4

Thread: Insert date and day in field

  1. #1

    Thread Starter
    New Member
    Join Date
    Feb 2012
    Posts
    3

    Question Insert date and day in field

    I need to insert dates and day in filed for current whole month like: (VB6 code)

    01-01-2012 Sun
    02-01-2012 Mon
    03-01-2012 Tue
    .
    .
    31-01-2012 Tue

    Thanks

  2. #2
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

    Re: Insert date and day in field

    You have to give more info than that.

    Insert into what for example.

  3. #3
    Smooth Moperator techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,532

    Re: Insert date and day in field

    Actually, it's very simple... make the field a Date or DateTime field (depending on the DB being used) ... and simply insert it using parameters and standard SQL.
    more info in the Database FAQ and Tutorial trhead.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  4. #4
    ASP.NET Moderator gep13's Avatar
    Join Date
    Nov 2004
    Location
    The Granite City
    Posts
    21,963

    Re: Insert date and day in field

    Hello kafsar,

    Since it would appear that you are asking a Database related question, for now, I am going to move your thread to the Database Development Forum which is where you should get the most help with your question.

    Let me know if you have any concerns with me doing this.

    Thanks for the report tg

    Gary

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