ITMikeK
asked on
case for date
I have select statement that includes the following:
DATEADD (mm,+1,(tblUser.BILLMON +'01') ) AS TransDate,
There are some instances where tblUser.BILLMON ='000000' (usually it is 201205...or something like that)
I want a case added to the beginning of this to handle the '000000'...how could I go about it?
DATEADD (mm,+1,(tblUser.BILLMON +'01') ) AS TransDate,
There are some instances where tblUser.BILLMON ='000000' (usually it is 201205...or something like that)
I want a case added to the beginning of this to handle the '000000'...how could I go about it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.