automate date in sql

[sonny1974]

im using sql server and crystal reports and crystal enterprise

i want to put in my where i want the begin date to be the first of every month.
for instance i have set this report to run may 29th, but i want the begin start date to be june 1,

then next month i want the begin start datre to be july 1.

how do i set it up in my where , that i dont have to change the date every month since this report will be scheduled on crystal enterprise

 

[xlbo]

How does this have anything to do with MS SQL Reporting Services ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question