Results 1 to 4 of 4
  1. #1

    Thread Starter
    New Member
    Join Date
    Feb 2012

    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


  2. #2
    Join Date
    Feb 2012
    West Virginia

    Re: Insert date and day in field

    You have to give more info than that.

    Insert into what for example.

  3. #3
    PowerPoster techgnome's Avatar
    Join Date
    May 2002

    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.

    * 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
    The Granite City

    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


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