已完成

Correct an issue with Date format on insert statement

OK so I have an asp.net 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,

Regards

Ben

技能: .NET, ASP.NET, C# 编程, 微软Access

查看更多: 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

关于此雇主:
( 56个评论 ) Bangkok, Thailand

项目ID: #18058098

授予:

masoodahmad782

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 在1天内
(0条评论)
0.0

3 威客就此工作平均出价 $29

Zahidtanveer

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!

$30USD 在1天里
(15条评论)
4.9
parmindersidhu

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 更多

$45USD 在1天里
(4条评论)
4.1