Query to fetch next two days record in SQL Server

chetan

SOLVED CLOSED ACTIVE ANSWERED
User: chetan
Posted: on Apr 20, 2020 12:52 AM
Forum: SQL Server
Replies: 3
Views: 2282

I want to fetch records in such a way that: Suppose today is Monday then i want to fetch records of Monday and next 2 days ie. Tuesday and wednesday.(Monday+ tuesday and wednesday) Suppose today is Tuesday then i want to fetch records of Tuesday and next 2 days ie. wednesday and Thursday.(tuesday+ wednesday and thursday) Suppose today is Friday then i want to fetch records of Friday,Saturday and Monday(here sunday should be skipped) Suppose today is Saturday then i want to fetch records of Saturday,Monday and Tuesday(here sunday should be skipped) How to achieve this using sql query or script?

Download FREE API for Word, Excel and PDF in ASP.Net

Andrea

0 1

Reply
User: Andrea
Replied: on Apr 20, 2020 12:52 AM
Report

Hi @chetan, Please try the following SQL Query to fetch records whose date is 7 days greater than current date It might help you. Cheers Andrea.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Query to fetch next two days record in SQL Server

Company

Explore

Follow us

Contact Us