Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Query - 1st to lastday of the month

Avatar of VBdotnet2005
VBdotnet2005Flag for United States of America asked on
Microsoft SQL Server
3 Comments1 Solution398 ViewsLast Modified:
I have a Windows app, this query DB and put a data in Excel. I schedule to run on last day of month in Win Scheduler task... the 30th.
If it run on the 30th, will it query from the 1st to 30th.? Actually, I really want it to query from the 1st to the lastday of the month, but not sure how.

Select mycustomer, dateordered, etc...from table where month(ordersubmitted) = datepart(month, getdate()) and year(ordersubmitted) = datepart(year, getdate())
ASKER CERTIFIED SOLUTION
Avatar of ralmada
ralmadaFlag of Canada image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answers