Correct an issue with Date format on insert statement

OK so I have an project, I've had to amend the general methods file so that other files in the project work now I am having an issue with an automated insert that should insert date +1 for a period between two dates as stated on the input form.

What's happening is for dates between 1/11/2018 and 30/11/2018, for dates up to 11 it formats the date as mm/dd/yyyy and after the 11/11/2018 follows dd/mm/yyyy. I need this particular page to insert as dd/mm/yyyy

From the values section of the insert query, you can see below that the date is just a text value box, I need to format it as dd/mm/yyyy on this particular part of the code.

query += " Values (" + BranchID + ", 'update', 'update', 'update', #" + LoadDate + "#, #" + LoadDate + "#, #" + LoadDate + "#, #" + IDate + "#, " + Payment_ID + ", true, '" + [login to view URL]() + "', '" + [login to view URL]() + "', yes, yes, yes ) ";

I've uploaded the entire page, the backend is microsoft access by the way.

Any help appreciated,



Habilidades: .NET, ASP.NET, Programación en C#, Microsoft Access

Ver más: truncated incorrect date value, how to insert date in database using php, sql insert date format yyyy-mm-dd, how to insert date in sql query, insert date sql oracle, incorrect date value: '0000-00-00' for column mysql, how to insert date in mysql, how to insert date datatype in sql, project vba date format, convrt data date format sql, hours date format access database, scriptaculous date format, date format asp via, copy date text date format excel, vb6 date format, excel changes date format csv, insert paypal website payment, date format indiancnet, date format, excel vba date format days

Información del empleador:
( 56 comentarios ) Bangkok, Thailand

Nº del proyecto: #18058098

Adjudicado a:


I will do it in much simpler way. I am looking forward to groom myself in the field of Web Development with the Technical skills.

$12 USD en 1 día
(0 comentarios)

3 freelancers están ofertando el promedio de $29 para este trabajo


Hi, Available for Immediate Start Contact me for Quality Work. Relevant Skills I have: ASP.NET / MVC / Linq / .NET Core / SQL HTML/CSS/Bootstrap, JS/Jquery, Git, TFS Thank You!

$30 USD en 1 día
(15 comentarios)

Hey Ben I can surely Correct an issue with Date format on insert statement.I have 5 + years experience in ASP.Net including the following skill set; Microsoft Visual Studio .Net IDE using C#, ASP.NET, SQL Server, M Más

$45 USD en 1 día
(4 comentarios)