Want to build the ChatGPT based Apps? Start here
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Hold On
1.2k
1.1k
225.1k
Retrieve Previous Years Data From SQL Server
Nov 13 2019 9:25 PM
I need an assistance again. Below is a snippet where I get a record from year to date:
WHERE
(DateIssued
between
DATEADD(
YEAR
, DATEDIFF(
YEAR
, 0, GETDATE()), 0)
and
DATEADD(MILLISECOND, -3, DATEADD(
YEAR
, DATEDIFF(
YEAR
, 0, GETDATE()) + 1, 0)))
What I need now is to get the record from previous year of the same date.
Thank you in advance.
Reply
Answers (
1
)
Parse an EDIFACT message to find a certain segment
how to post image from our application to linkedin post ?