Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Sharepoint Date Column

  Asked By: Stella Dillard         Date: Mar 26, 2010      Category: Sharepoint      Views: 256
 

I have a Sharpoint Document Library with a couple of additional columns, two
of which are dates. When I link to that list from Access, and try to assign a
date to one of the date fields (using vba), I get a consistent message saying
the field is too small to hold the string I'm trying to assign to it.

I tried everything, using the NOW() function to ensure I was getting a good
date. I assigned it directly, formatted it as YYYY/MM/DD, YYYY-MM-DD,
MM/DD/YY, every possible incarnation of dates, and get the same error message
each time.

Any ideas?

Tagged:      

 

1 Answer Found

 
Answer #1       Answered By: Lacey Daniels          Answered On: Mar 26, 2010       

Did you define the SharePoint columns  as "Date and Time" or "Date Only"?
Your VBA code may be passing both the date  and time. Please post the
relevant VBA code.

 
Didn't find what you were looking for? Find more on Sharepoint Date Column Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].