DateAdd Function

[renee35]

Could someone please help me figure out how to change the below code:

a.effdate between @PrevQtrClose + 1 and @enddate

to say between @PrevQtrClose + dateadd (sec + 1)?

What I need is to capture all data between the prevqtrclose and the next day, and right now I missing anything that falls in between.

Thanks!

Thanks a bunch!!

-T

 

[gmmastros]

You want to add 1 second to @PrevQtrClose?

So... this?


a.effdate between DateAdd(Second, 1, @PrevQtrClose) And @EndDate

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[renee35]

Thanks, got it!!

Thanks a bunch!!

-T