Forum Replies Created
Viewing 15 posts - 241 through 255 (of 842 total)
-
RE: Are the posted questions getting worse?
Jeff Moden - Tuesday, March 19, 2019 7:25 AMbelow86 - Monday, March 18, 2019 8:38 AMRE: Today's Random Word!
Jeff Moden - Monday, March 18, 2019 4:11 PMRE: Are the posted questions getting worse?
Sean Lange - Monday, March 18, 2019 7:29 AMjonathan.crawford - Friday, March 15, 2019 9:21 AMRE: Today's Random Word!
Ed Wagner - Wednesday, March 6, 2019 7:56 AMDesNorton - Wednesday, March 6, 2019 7:11 AMRE: Today's Random Word!
Ed Wagner - Tuesday, March 5, 2019 6:40 AMDesNorton - Monday, March 4, 2019 9:36 PMRE: Today's Random Word!
Ed Wagner - Thursday, February 28, 2019 5:36 AMHappyGeek - Thursday, February 28, 2019 3:07 AMRE: Convert string MMDDYYYY to a date
New week, new results. I ran the SQL on our Dev and Prod servers. At this point the 'DateFromParts2' is my winner. I'll start with that and see what happens.
RE: Age Range From Today's Date
ScottPletcher - Monday, February 25, 2019 10:13 AMRE: Age Range From Today's Date
ScottPletcher - Monday, February 25, 2019 7:58 AMRE: A Good Benefit?
We get 10 paid holidays and a little over 4 weeks of PTO. But the PTO includes your sick time for the year, no banking that, you can carry over...
RE: Age Range From Today's Date
ScottPletcher - Friday, February 22, 2019 12:14 PMYou are correct on the...
RE: Convert string MMDDYYYY to a date
Just getting back to working with this, so I thought I would test this out again.
My first run on our Prod server had these results:
I then ran it...RE: Age Range From Today's Date
below86 - Friday, February 22, 2019 12:04 PMRE: Age Range From Today's Date
ScottPletcher - Friday, February 22, 2019 10:39 AMRE: Age Range From Today's Date
Wouldn't it be more like this?
WHERE Birthdate >= DATEADD(YY, -65, CAST(GETDATE() AS DATE))
AND Birthdate <= DATEADD(YY, -12, CAST(GETDATE() AS DATE))Viewing 15 posts - 241 through 255 (of 842 total)
