Link to home
Create AccountLog in
Avatar of metropia
metropiaFlag for United States of America

asked on

explanation on query

Hello,

I would like to ask if someone could explain to me what the WHERE clause is doing with the field desiredDate.

Thank you!
WHERE     
(CAST(DesiredDate AS DateTime) <= DATEADD(day, - (1 * DAY(GETDATE())), DATEADD(month, 1, GETDATE())))

Open in new window

SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of metropia

ASKER

excellent, thank you very much!