Need some work done? Post a Project Today
I have a mysql database that has an export and import feature as part of the script. Another script that uses the data and dates in the database requires the dates in this format: 2009-04-03 but the current import is formatting the data like this: 04/03/2009
I need the import script to format the csv file data into the correct format. 2009-04-03
Attached is a file with the import action. It should give you and idea as to what is happening. If the format occurs in another file you will need to request it.
This task requires getting the script to import the data in two fields, start date and finish date in the correct format so that the other script will process the data correctly.