+ Reply to Thread
Results 1 to 5 of 5

Help with uploading blank dates in my spreadsheet

  1. #1
    Registered User
    Join Date
    04-20-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question Help with uploading blank dates in my spreadsheet

    Hi guys, this is my first time here and I have a dilemma, so my system at
    Work allows me to do mass uploads with excel spreadsheets
    Instead entering in data line by line, however
    There is a date column in which gets uploaded as well. The
    Problem is if I upload a blank date field(which is what I want)
    It will not upload the blank, for example in my current data I have
    1/12/2012, but want to replace with a blank date. However
    When I upload it says the blank data in the spreadsheet is not
    In mm/dd/yyyy format and is invalid. I've tried using "" which
    Comes back with the same error as well, any advice?

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Help with uploading blank dates in my spreadsheet

    what is the field type of the uploading system for the date?

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644
    How are you uploading the data?
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    04-20-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Help with uploading blank dates in my spreadsheet

    Just short date format SQL datetime, not sure if you're referring to that

  5. #5
    Registered User
    Join Date
    04-20-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Help with uploading blank dates in my spreadsheet

    So the software which is Internet HTML format allows excel uploads into the database takes xls spreadsheets to upload large data

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1