I have a program that imports times/dates from a CSV file that is polled from an external computer.

This is the format of the CSV file:

1,9,3,7042010,1229,1,0,0
2,5,6,1052010,1024,1,0,0
3,3,6,1052010,1047,1,0,0
1,3,6,1052010,1,2,0,0
2,3,6,1052010,20,2,0,0

Here you can see that the date format comes in as d/mm/yyyy I need it to be dd/mm/yyyy also the time after midnight is the same it comes in as mm and misses the hh.

The date problem only happens on single date when it hits the 10th day it is fine. Also the time format it only happens for the midnight any other time is fine.

I need to fix this problem either before it is imported into SQL or after either way it does not make any difference.

this needs to be complete before the end of the weekend.

Requirements Interview Answers:
To help you bid more accurately, the buyer was interviewed about the requirements for this bid request. Below are their answers.

Bid request Type: What kind of work do you need done? Software related (Includes desktop applications and internet websites) Bid request Parts: What do you want the worker to do on this bid request? Requirements: The worker will analyze the problem and propose a software-based solution to the problem. Programming: The worker will take the requirements and translate them into the language of the computer (and test it). User installation: The installer will move the software from the place it was created (which is called the development or QC environment) to where you will use it (which is called the production environment). The installer then tests the software to make sure that the installation was done properly and completely. Req. Doc. Type: What kind of documentation do you want for this bid request? Informal documentation - As the buyer talks back and forth about the bid request with the worker, those conversations become the requirements.Remember to communicate ALL of the details of your bid request on the Rent A Coder site. If you don't, and there is a dispute, then important details of the contract will not be documented and cannot be taken into account in arbitration. If you feel you MUST go offsite (for example, using the phone or IM) then afterwards post everything onsite and get the other party to post that they agree to those contractual terms. Program Type: What kind of software should the worker create (and/or install)? A desktop or server program: This software runs on a user's own PC/workstation, or on a server. Desktop / server program info Size of application: How many screens/forms need to be created/edited in this application? Exactly 1. Programming Language: What programming language(s) do you want your application written in? I do know the language(s). Languages(s): Visual Basic .Net Operating system(s) What operating systems(s) do you want your application to work on? I do know the operating system(s): Microsoft Windows -- version(s): xp, vista, 7 Database: Will this bid request include a database? Yes, it does include a database. Details: SQL Server -- version(s): 2005 Installation Program: Does the worker need to create an installation program? No. The worker needs to only give me instructions on how to install it. Legal: 1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future). 2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables): 2a) If there are any server-side deliverables (intended to only exist in one place in the Buyer's environment) then they must be installed by the Worker in ready-to-run condition (unless specified elsewhere by the Buyer). 2b) All other software (including but not limited to any desktop software or software the buyer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request (unless specified elsewhere by the Buyer). 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. 3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the worker's Worker Legal Agreement.

Other Requirements:

• All deliverables must be uploaded to Rent A Coder before the deadline(s) for this bid request...with no exceptions. If this contract makes it impossible for a competent person to do this, then do not start this bid request...but instead alert Rent A Coder of an un-arbitratable, illegal bid request.
  
• Remember that contacting the other party outside of the site (by email, phone, etc.) on all business bid requests <$500 (before the buyer's money is escrowed) is a violation of both the software buyer and worker agreements. Rent A Coder monitors all site activity for such violations and can instantly expel transgressors on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.

Categories:
(Note: Like everything else on this page, these categories are part of the original contract for this bid request.)
Microsoft Windows, Database, Languages, Requirements, Operating systems / platforms, Other (Technology), Visual Basic .Net, SQL Server, Software related (includes websites)

Additional Files:

This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.

3,105.60 kb