Results 1 to 2 of 2

Thread: when enter a date into a table, i am getting as time format in MS access

  1. Apr 29th, 2012, 10:49 PM #1
    kornkarthik
    kornkarthik is offline

    Thread Starter
    New Member
    Join Date
    Jul 2011
    Posts
    13

    when enter a date into a table, i am getting as time format in MS access

    Hi When i try to insert a date into a table, its inserting as a time format i have no idea. Can anyone please help me. Thanks


    Regards
    Karthik
    Reply With Quote Reply With Quote
  2. Apr 30th, 2012, 01:19 PM #2
    sweet_dreams
    sweet_dreams is offline
    Addicted Member sweet_dreams's Avatar
    Join Date
    Apr 2005
    Location
    Poland, Lodz
    Posts
    189

    Re: when enter a date into a table, i am getting as time format in MS access

    Hi,

    How are you trying to insert date into table?
    Are you using VBA? If yes do you put "#" signs around date?
    What data type is field that you are trying to insert date to?

    More information are needed to help you out.

    Regards,
    Sebastian
    using VB 2010 .NET Framework 4.0; MS Office 2010; SQL Server 2008 R2 Express Edition | Remember to mark resolved threads and rate useful posts.
    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