Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

Compare two Dates from back end and front end

Home
Forums
Learn iOS Programming

Compare two Dates from back end and front end

Abhishek Soni

17yAsked Jan 21, 2009, 6:16 AM4.7kLearn iOS Programming

I am working in instute site in which i allocate batches for faculity i want that a batch which is running between particular dates no other batch is scheduled at that period.

I have used between query for start date between start and end date in database.But not getting proper validation.

Please revert me back

thanks & regards

Abhishek

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Guest User17y ago
Why are you converting your dates to varchars and then back to dates? Is it because you're trying to remove the time portion of the datetime fields?
Niradhip Chakraborty17y ago
I am selecting from date and to date from a dropdown list.

Syntax should goes like this:

select * from Transactionlogs where Convert(datetime,convert(varchar,tlg_dtm_Datetime,101),101) between Convert(datetime,convert(varchar,'" + dtpFromdate.Text.ToString() + "',101),101) and Convert(datetime,convert(varchar,'" + dtpToDate.Text.ToString() + "',101),101)";
Guest User17y ago
Can you post your query?